Inserting columns

Question

I tried with both relative cell references and absolute references. I tried recording a macro and writing it in VBA.

It is supposed to take raw data and format it. This includes inserting two new columns to add Notes.

I have included a snip of the macro. I know the problem is not with the rest of the macro because the issue happens when I use this alone.

Rows("1:1").Select
Rows("1:1").Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
Selection.ClearFormats
Columns("B:B").Select
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
Range("B3").Select
ActiveCell.FormulaR1C1 = "Date"
Range("F3").Select
ActiveCell.FormulaR1C1 = "Notes"

I have a feeling it's related to using .Select. It's highly suggested to avoid doing so. — BruceWayne
– BruceWayne, Commented Sep 26, 2016 at 18:50
Thank you. I will try. I am a total novice.. I am looking at how to use Activate and variables but I doubt I will be able to figure out how to use those to do the same thing without hitting many brick walls along the way. Ah well. — Desi D
– Desi D, Commented Sep 26, 2016 at 19:06
We all hit brick walls to get to where we are, and expect to hit many more. The key is to realize you can go around/through the walls by digging around, asking questions, and trying alternatives. — BruceWayne
– BruceWayne, Commented Sep 26, 2016 at 19:08
Ha! I think I have got something!' Range("B1").EntireColumn.Insert Range("A1").EntireRow.Insert :) Seems to work well enough I think. — Desi D
– Desi D, Commented Sep 26, 2016 at 19:14

Doug Coats · Accepted Answer · 2016-09-26 19:31:26Z

1

this should probably help, i hope

Private Sub thisorthat()
Sheets(6).Columns("B").EntireColumn.Insert
End Sub

answered Sep 26, 2016 at 19:31

Doug Coats

7,2179 gold badges32 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

BruceWayne Over a year ago

Ha, nice catch!

Doug Coats Over a year ago

I shouldve read the comments before blindly posting, OP was very close already. @BruceWayne

BruceWayne Over a year ago

And I should've read the code instead of blindly saying it's probably due to .Select, :P

Collectives™ on Stack Overflow

Inserting columns

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related