vba help to find cell based and delete rows

i am trying to figure out how to write the vba to locate a cell based on its value and then delete that current row and all rows that fall above it.

its works great but only works every time if i select the cell that contains the value i am looking for first. is there a way to may it select the cell that contains what i am looking for before the rest runs.

Originally Posted by Olly

Something like:

Please Login or Register  to view this content.

that worked great. thank you. cant believe i missed that line to set my range, but i guess that means i need to sleep after being up 2 days working on this crazy book.

Originally Posted by Olly

Just change this line:

Please Login or Register  to view this content.

to whatever you need it to be. This determines which range is searched for your value. So if you want to look everywhere in the active sheet, you could use:

Please Login or Register  to view this content.