Hi
Columns("A:F").Insert Shift:=xlToRight
--
Regards
Roger Govier
"SITCFanTN" wrote in message
...
What would the VBA code be to insert 6 columns to the left of Col A? I
recorded a macro but I know there has to be a quick line of code that will
do
the same things rather than 10 lines of code from the macro recorder.
Thank
you.
__________ Information from ESET Smart Security, version of virus
signature database 4751 (20100107) __________
The message was checked by ESET Smart Security.
http://www.eset.com
__________ Information from ESET Smart Security, version of virus signature database 4751 (20100107) __________
The message was checked by ESET Smart Security.
http://www.eset.com