Assuming the sheet the user was originally on is Sheet1

Private Sub CommandButton1_Click() 'Use actual button name
Sheets("Sheet1").Range("C2").End(xlDown).Offset(0, 3).Select
End Sub



"Jock" wrote in message
...
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