Deleting columns

[JohnnyBoyxxx]

Any one else bored today that can help with this simple issue. I need to be able to delete column 47 (AU) and its entire contents immediately after running this piece of code

Please Login or Register  to view this content.

Maybe it could be added to this piece of code it that's any easier.

I know it's Christmas but if you're bored like me then i'd appreciate your help.

Regards
John

[Sbarro79]

Try add

Please Login or Register  to view this content.

at the end of your code

[berlan]

Try this:

Please Login or Register  to view this content.

[JohnnyBoyxxx]

Sorry i forgot to mention that the code runs in the second worksheet called 'new' and the column that needs to deleted is in the first worksheet called 'Desktop'

[berlan]

In that case, try this:

Please Login or Register  to view this content.

[JohnnyBoyxxx]

Thanks to all, I used the code berlan provided and it did the trick. Many thx. (rep added)