Hi all,

Can someone tell me what code to put in my macro to enable it to delete
any cell on Sheet1 containing "Word1" "Word2" "Word3" and so on?

When I copy data from our website into excel it contains headings that I
have to delete manually before doing my macro. The headings vary from
day to day so I need to be able to have the macro search for and delete
any or all of them.

Thanks