How do I insert multiple columns?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there

I know this is probably really simple but i'd appreciate any help.

I need to insert say 6 blank columns starting from column A. Now I can do
this by inserting column after column, but surely there is a simpler way of
doing this, maybe with just one line of code?

Thanks in anticipation

Cheers
Linds
 
Hi Linds

select the column header A, drag across to F then right mouse click and
choose Insert (or insert the columns any way you want)

Cheers
JulieD
 
Hi, Lindsey-
Do you want/need to do this with code? If you highlight columns A thru
F and perfrom the insert operation, you'll get six blank columns.
 
Hi Dave

I do need to do it in code, but i've done it now - i can't believe how
simple it was!

Columns("A:F").Select
Selection.Insert Shift:=xlToRight

Cheers
Lindsey
 
Dave, I am trying to insert columns to an existing sheet with formulas
already built in and when I try to insert a column (sometimes it does....and
sometimes it doesn't) I get an error message. Keep in mind I am a relative
novice.
 
One thing for a relative novice to learn is that you've got a better chance
of help from the group if you tell us WHICH error message you are getting.
 
Back
Top