View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rroach[_4_] rroach[_4_] is offline
external usenet poster
 
Posts: 1
Default delete all rows above a selected cell


I have a macro that selects a specific (and different in each worksheet)
cell based on cell contents. From that cell location (it is the
activated cell at current step of macro) I want to highlight and delete
all rows in the worksheet above to the top of the worksheet. I'm stuck.
Any ideas?


--
rroach
------------------------------------------------------------------------
rroach's Profile: http://www.excelforum.com/member.php...o&userid=21093
View this thread: http://www.excelforum.com/showthread...hreadid=378687