if cell=value select range and either clear contents or delete rows

[maxx_daddy]

Hi All,
I have a sheet that duplicates the header when exported.
I want to search a column and if a certain value exists either select a range surrounding the active cell and clear the contents or better yet select the rows containing the header and delete them.
I should be able to write the seach, but having some trouble with selecting active rows or generating the range.

thanks
Joe (Maxx's Daddy!)

 

[Michael M]

Hi Joe
What value do you want to search for and in which column ??

 

[maxx_daddy]

Lets just say for grins that I want to search column G for a cell that has the words "pink elephant"
and i want to pick a range of cells 5 up and 6 down and 20 to the right and 5 to the left and clear contents or I could just go 5 rows up and 6 rows down and entire row delete. thanks as always and it's good to be back.
joe (maxx's daddy)

 

[maxx_daddy]

I fixed this by changing some ranges around. While this would still be handy to know how to do, This is done.