I recorded a macro to copy a sheet and delete column B.
When I execute the macro, it copy the sheet and deletes column B but it ALSO eliminates column A. Not good
Here is the code that I use, help is appreciated
--------------------
Sub Copy1()
' copy sheet
Windows("price_Autocad-May-06-02.xls").Activate
Sheets(" US ASC").Select
Sheets(" US ASC").Copy Before:=Workbooks("price_S.xls").Sheets(2)
' delete column B
Columns("B:B").Select
Selection.Delete Shift:=xlToLeft
End Sub
-----------------
When I execute the macro, it copy the sheet and deletes column B but it ALSO eliminates column A. Not good
Here is the code that I use, help is appreciated
--------------------
Sub Copy1()
' copy sheet
Windows("price_Autocad-May-06-02.xls").Activate
Sheets(" US ASC").Select
Sheets(" US ASC").Copy Before:=Workbooks("price_S.xls").Sheets(2)
' delete column B
Columns("B:B").Select
Selection.Delete Shift:=xlToLeft
End Sub
-----------------