How to activate a past activecell

not picking up the right cells for some reason, but that's a much nicer code! thanks!

I'll try adjusting it so I can get it to pick up the right numbers (relating to "Z").

edit: needed to change .Offset(0, -8).Value to .Offset(n, -8).Value, working perfectly now!!! thanks so much!

Yep, well spotted. Sorry about that!