| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
to previous location
i want to go to previous location for excel using. Namely, to previous sheet or previous cell. how can i? *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
to previous location
Hi X Taol,
Try something like: '============= Public Sub Tester001() Dim rng As Range Set rng = ActiveCell 'your code, e.g.: ActiveSheet.Next.Select Application.Goto rng End Sub '<<============= -- --- Regards, Norman "x taol" wrote in message ... i want to go to previous location for excel using. Namely, to previous sheet or previous cell. how can i? *** Sent via Developersdex http://www.developersdex.com *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 3-Color Scale Vlookup for Current Month/Previous/Pre-Previous | Excel Discussion (Misc queries) | |||
| Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
| Hyperlink or Other Method To Return To Previous Location (Sheet) Possible? | New Users to Excel | |||
| shortcut to go to previous location or cell | Excel Discussion (Misc queries) | |||
| Returning to a previous location | Excel Programming | |||
Linear Mode
