yeah sorry, have changed the offset Syntax now 

ActiveCell.Row
Range("table1[location]]").Select
Selection.End(xlUp).Select
Offset(ActiveCell.Row, 0).Select

what Im trying to do is move horizontal to another location on a spreadsheet with a command button click instead of having to scroll

with the code above i'm looking to move across to a column however would like to remain on the same active cell row when moving

so if im on cell a100 on the first column and would like to move to the 'location' column which is 15 columns to the right, I would click on the command button and it will move to the column and keep me on the same row.