hello
I would like to know how can i select a range of cells on the basis of
the a particular search

For eg
I have some data in excel which has a row above it with a particular
name say "Corporate" and teh data ends with "Total of Corporate" and i
want to select the range in between this two searches.
how should i go about

Regards
Sandeep