Not sure what you mean by "refer to". You can refer to individual
cells in a range using
bigRange.cells(x)

if that's what you're after. Since they are single-column ranges
cells(5) will be the fifth row. If this doesn't help maybe you can
provide more details.

Tim.






"tim" wrote in message
...
Howdy,

I have two ranges (smallRange and bigRange) that I am working with,
both are
1 column wide and variable (dynamic) in length but bigRange is
always longer
than smallRange.

Now for the twist, the values in the smallRange refer to the row in
the
bigRange, and I want the value from the bigRange. Any
thoughts/suggestions

Regards,
Tim