Last key stroked before auto macro run

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

auto shift down a cell after entering data 1
The next Grand Theft Auto title has been officially announced 0
Manual format of inbox message VBA code 2
Virus checker 7
auto shift down a cell 1
Is it possible to have an image as a background? 0
Keyboard Macro Recomendation Request 2
Macro for data and time 2

Back
Top