Selecting a number of rows based on the content

[t16turbo]

Hi there,

I have managed this before, and subsequently lost the file I was working on.
Being a total amateur in VBA I'm hoping that someone will be able to nudge me in the right direction!:


I need to create a range of rows (columns are not required - just entire rows)

an example logic is:
In Column A, find "Very Likely Projects" - this is the first row in the range
In Column A, find "Very Likely Projects Total" - this is the last row in the range.
Select the range.


simple, yes - can I remember hw to do it? no!
any help will be gratefully recieved.

thanks in advance

 

[SkipVought]

This solution was posted for you, I believe, in some past thread along with one of my FAQs regarding Dynamic Ranges.

Regardless, a SEARCH sould turn up a solution.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[t16turbo]

I have searched for it under my threads, but cannot find it.
i'll have another look.

thanks,

 

[t16turbo]

found it!
panic over!! ;-)