Deleting a Column

K

Ken

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.
 
G

George Nicholson

What sheet? Workbooks or Windows don't have a Columns collection for you
delete anything from. Worksheets do.

Workbooks("SOA.xls").ActiveSheet.Columns("A").Delete
Workbooks("SOA.xls").Worksheets(1).Columns("A").Delete
Workbooks("SOA.xls").Worksheets("Sheet 1").Columns("A").Delete

should all work
 
Top