Hi guys I am new to VBA and I am trying to write a macro that
allows me to search for a certain value in a cell and then delate all
the rows above that specific cell. I have written a code to find the
specific cell,
but how do I find out what row that cell is in so I can delete the ones
above it?

Is there anyway to store the row number of a selected cell in a
variable?

Your help would be much appreciated.


--
jnasr00
------------------------------------------------------------------------
jnasr00's Profile: http://www.excelforum.com/member.php...o&userid=28515
View this thread: http://www.excelforum.com/showthread...hreadid=481723