View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steven Rosenberg[_2_] Steven Rosenberg[_2_] is offline
external usenet poster
 
Posts: 5
Default Dynamically locating value; selecting that row and everything above (or below) and deleting/copying

How can I write a VBA macro which:

--will locate a specific value (a word) in column A of a
multi column worksheet; then

--select that cell's entire row, and all rows above (or
below) it; then

--delete the selected rows?

This non-programmer would appreciate any and all
help.

Steven

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!