I am trying to build some code and at some point I need to select cells 120 to 127 within the column that is already active. So, say im in V22, I want VBA to select V120 to 127. If i'm in Z65, I want VBA to select Z120 to 127. Etc

I can't seem to find how to do this altough it seems quite simple.

Thanks