Previous Topic Next Topic

Selecting a range based on a found cell

Closed
NewToVB - 27 Aug 2009 à 05:29
sarbel.vilo Posts 233 Registration date Tuesday 18 November 2008 Status Member Last seen 1 August 2010 - 27 Aug 2009 à 05:45
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

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

Similar discussions

Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses