Cells Relative to a Range
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.
|