I'm assuming you're trying to find a value within a worksheet range; please
confirm. What method have you tried to find the value? Are the elements of
your public type unique or similar?

It would be helpful if you post your code so that we may provide assistance.


"Aaron Dyck" wrote:

I am writing a routine that looks for a value (variable name sLOB) and
returns the next seventeen values into a public type. I am having some
difficulty doing this. Is there an easy way to do this? I was thinking that
maybe using the offset command to return the values, but the part I am having
trouble with is finding the data. Could someone help me please?