I want to go to the last populated cell and then select the next 10 X 6
cells down. I am not sure how do this using offset but it does need to be
variable since my list varies in length.

Ex.

Last cell with a value is A117 ( I can use the end down to get there) I want
to select range (A118:F128)

I have tried several guesses and none have worked so far.


Thanks