Assign variable for next available row?

This code finds the second avaliable row from the top of the sheet.

Please Login or Register  to view this content.

How can I assign a variable for the next row without using the same command again?

I'm looking for a more efficient method to find the next seven rows after the row found by the code above.

Do you meant something like

Please Login or Register  to view this content.

If this is in a loop, you could mean something like this

Please Login or Register  to view this content.

John