Deleting a Column
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. |
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. |
All times are GMT +1. The time now is 09:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com