Deleting a Column

  • Thread starter Thread starter Ken
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Changing a csv file opened as hidden workbook 13
Sheet name is not visiable. 5
Import multiple workbooks to current workbook in specified row number 0
Deleting columns on multiple sheets 4
Delete Columns 7
VBA insert column with two workbooks open 1
Run macro on all files in a specific folder 3

Back
Top