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

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