| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Last key stroked before auto macro run
Can I know the last stroked key on KB before a macro has been auto run?
This is because i want to direct of move of selection after an auto macro has been run |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Last key stroked before auto macro run
You can identify the last cell that was accessed before the macro was run.
Assign a range to ActiveCell at the beginning of the macro and then select that range at the end of the macro. You may need to identify the worksheet using RANGE.Parent if you move between worksheets. "Khaled" wrote: Can I know the last stroked key on KB before a macro has been auto run? This is because i want to direct of move of selection after an auto macro has been run |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Auto Run(2) | Excel Worksheet Functions | |||
| Macro - Auto Run | Excel Worksheet Functions | |||
| Auto Filter Macro | Excel Discussion (Misc queries) | |||
| macro for auto sum | New Users to Excel | |||
| Auto Run a Macro | Excel Discussion (Misc queries) | |||
Hybrid Mode
