Hi!

I am wanting to select the second row of a column to the end of my data for that column and then to insert a column to the right, avoiding the first row entirely.

Here is what I was trying to do (unsuccessfully):


Range("A2:" & (Cells(Rows.Count, "A").End(xlUp).Row)).Insert Shift:=xlToRight

Can someone help me to fix this little problem?

Thanks!