Phillip,
You can also use the following notation (just another way)
ActiveSheet.Range(Columns(1st column #),Columns(last column #)).Delete
this notation just makes it clearer that you are working on columns.
steve
"phillip harrison" wrote in message
...
Rob
That works a treat.
Thank you for your help
Phillip
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!