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
0
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 ?
0