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)

wrote in message
ups.com...
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.