excel vba, find a range

Question

In excel, everyday i have to find where "spot" in the cell and then select after this row befor the cell containing "public".

can any one help me How to find rows contains "spot" and end selection before containing cell "public".

Answer 1

Yes.. looks very much like a homework assignment...

Here's a hint -

First search for the word spot, note the row number, then search for the word public then not the row number and then select the rows between

Hope this helps :)

Cheers... Nilesh