Anyones help would be rgeatly appreciated, it shouldnt be har
but...here i am!

I need a macro to find a certain value in a worksheet(the same valu
everytime) and then delete the row that contains that value and al
rows beneath that row. There will only ever be one occurence of th
specific value in the worksheet.

The position of the value may change every time i use it e.g it may b
on row 250 one time and on 300 the next etc

So i need a macro to find what row the value is on and delete it an
all rows below it, if anyone could help that would be brilliant!

--
Steel Monke
-----------------------------------------------------------------------
Steel Monkey's Profile: http://www.excelforum.com/member.php...fo&userid=2905
View this thread: http://www.excelforum.com/showthread.php?threadid=54768