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.

Selecting a range based on a found cell
Excel macro to create new sheet based on value in cells - Guide
Clear only the formatting from the selected cell (leaving the content) - Guide
Which key is used to make multiple line in a single cell - Guide
If cell contains specific text then return value in another cell ✓ - Excel Forum
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum

2 responses

Answer 1 / 2

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

Answer 2 / 2

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 ?

Similar discussions

help me to add particular cells

How do I change a base location on Instagram?

Why can't I bridge connect?

Counting cells containing only numbers

Facebook says that my email doesn't match my facebook email

Similar discussions

Subscribe To Our Newsletter!