Defining a range based on a row containing a certain row

[nickos]

Hi,

I have looked in a number of places to find some code that will do the following, but my search has been unsuccessful so far.

I know which row in my worksheet I want to use as the bounds for defining my range, but the only way I can identify this row is that the second column contains a particular piece of text (string).

Is there anyway you can define a range based on a row with text criteria?

Nickos.

 

[pgc01]

Hi Nickos

You can find the cell where the text is with the method Find (Check the help).

Use that cell to build your range.

Hope this helps
PGC

 

[nickos]

Thanks PGC, I'll give it a try.