In any cell in column "F", a user can select a code number from a drop down
list. These numbers go up to over 100, so, if the user isn't sure of which
number to select, cell F6 can be rightclicked and VBA will take the user to a
different sheet where all the code numbers (and their associated meanings)
are listed.
A command button on that sheet will take the user back to the ActiveCell on
the first sheet. Even if the user was working in cell F2000, the active cell
is now always F6
To get around this, how can I set the active row to the bottom most row with
data in "C" and then Offset from that cell to then make the active cell in
"F" on the same row?
--
Traa Dy Liooar

Jock