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.