Selecting a range based on a found cell

Closed
NewToVB - Aug 27, 2009 at 05:29 AM
sarbel.vilo Posts 233 Registration date Tuesday November 18, 2008 Status Member Last seen August 1, 2010 - Aug 27, 2009 at 05:45 AM
Hello,


I am new to visual basics and I am trying to delete the next 5 rows after I have found the cell that contains the data I requie. I have done a find to allocate the activecell. I have then offset this to the row below.

Any simple help would be appreciated.

2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Aug 27, 2009 at 05:43 AM
take a sample file. RECORD a macro making steps you require and edit the macro. That is the best way of learning vba
sarbel.vilo Posts 233 Registration date Tuesday November 18, 2008 Status Member Last seen August 1, 2010 31
Aug 27, 2009 at 05:45 AM
I didn't understand your problem, what do you need ??? It's to recover the lost data ?