Hi
In VBA, if I need to select the right most cell, is not the code
for each cell in range etc.
cell.end(xltoleft).select
e.g. if in row 5, ranges ( a5, d5, g5 ) contained data and I wanted to select g5 in a macro
would not the code be [a5].end(xltoleft).select
But this doesn't work?
In VBA, if I need to select the right most cell, is not the code
for each cell in range etc.
cell.end(xltoleft).select
e.g. if in row 5, ranges ( a5, d5, g5 ) contained data and I wanted to select g5 in a macro
would not the code be [a5].end(xltoleft).select
But this doesn't work?