Moving Column in Excel

[astonmak]

Dear all,

If I want to move the columns(4) to after columns(2) in Excel 2000, Then what is the code will be?

I have try :
WorkSheets("Sheet1&quot.Columns(4).Move after:= WorkSheets("Sheet1&quot.Columns(1)

But it was a error.


Thanks
Aston

 

[ADoozer]

give this a try:-

Columns("D&quot.Select
Selection.Cut
Columns("C&quot.Select
ActiveSheet.Paste

good luck!

If somethings hard to do, its not worth doing - Homer Simpson
------------------------------------------------------------------------
A General Guide To Excel in VB FAQ222-3383
The Great Date Debate Thread222-368305
File Formats Galore @

http://www.wotsit.org

or

http://www.filext.com