With the above, once the selection changes on the second line of code the 'a' active row location number will be different as the current selected cell has changed![]()
a=Activecell.Row Activecell.Row range("table1[location]").Select selection.End(xlup).select Offset(a, 0).select
Is there a way to store the row number in the first 'ActiveCell.Row' line of code for reference in the 'Offset(a,0).Select
Many thanks
Bookmarks