I've got a loop thus:

For Each rFunctionKey In Range("AU22:AU25")

Within that loop, I need to get the value from cells that are 100
cells further down the active sheet, how do I get that data?

Thanks.

For Each rFunctionKey In Range("AU22:AU25")
With rFunction.Offset(100,0)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I've got a loop thus:
>
> For Each rFunctionKey In Range("AU22:AU25")
>
> Within that loop, I need to get the value from cells that are 100
> cells further down the active sheet, how do I get that data?
>
> Thanks.
>