Excel macro needed for deleting column contents and column as well

[talktorajpatil]

Hi folks,

I have an excel sheet with multiple tabs and multiple columns with randon sequence on each tab.
I have two requirements -
1) I want to delete entire columns iteself from all the tabs of excel with value in 1st row as 'Select' or 'Start'
2) I would like to clear the contents (and not to delete column) with value in 1st row as 'Prompt'. (Value in 1st row should not be deleted)

I am novoice to VBA Macro for excel. Can anyone give me a complete macro for it?
Detailed help is appreciated.
Thanks in advance.

-Regards,
Raj Patil

 

[Michael M]

Have a look at one of the sheets and Press CTRL + End
Where does the the cursor go to ??
If it's a long way from the last used cell, the excess rows and columns will need to be deleted

BUT, the code shouldn't be causing that problem