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.

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.