Deleting a Column
What sheet? Workbooks or Windows don't have a Columns collection for you
delete anything from. Worksheets do.
Workbooks("SOA.xls").ActiveSheet.Columns("A").Dele te
Workbooks("SOA.xls").Worksheets(1).Columns("A").De lete
Workbooks("SOA.xls").Worksheets("Sheet 1").Columns("A").Delete
should all work
--
George Nicholson
Remove 'Junk' from return address.
"Ken" wrote in message
...
In a macro in workbook A I am trying to delete column A in
workbook SOA.xls. This code doesn't seem to work.
Windows("SOA.xls").Columns("A").Delete
What is worng with this syntax?
TIA.
|