Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how read value from last selected cell? It is possible? how get adress last selected cell? | New Users to Excel | |||
Perform oiperations relative to initial selected cell | Excel Discussion (Misc queries) | |||
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
make a cell empty based on condition | Charts and Charting in Excel |