how do i make it so that when a sheat is selected either via link or tab, that xlLastCell is selected. the last on the sheet.
 

how do i make it so that when a sheat is selected either via link or tab,
that xlLastCell is selected. the last on the sheet.

Use the sheet activate event. Right click on the sheet tab, select view code
and then paste this event code onto the code sheet.

Private Sub Worksheet_Activate()
Cells.SpecialCells(xlCellTypeLastCell).Select
End Sub

Hope this helps
Rowan

"Daniel" wrote:

how do i make it so that when a sheat is selected either via link or tab,
that xlLastCell is selected. the last on the sheet.