VBA when deleting columns

[Phanmore]

I'm recieving an error message when running the following code:

Range("D:DA").EntireColumn.Delete

The error message I am receiving is:

'Cannot shift object off sheet'

I'm using excel 2003.

any ideas?

 

[mirabeau]

If you try

Range("D:DA").Delete xlToLeft

does it work?

 

[Phanmore]

I've just found the problem, so I didn't try your code.

I had 2 comments on the sheet. I removed them and all works fine.


Thanks for you answer though, much appreciated.