stop annoying cell selection change

  • Thread starter Thread starter mark kubicki
  • Start date Start date
M

mark kubicki

i have a sub that monitors for change events in a range of cells, if a cell
changes, then some calcs are run (simple)

the change typically "occurs" when the user hits enter, moving the
cursor/selection to the next cell (up, down, left, where ever)...
BUT
after the calc, the cursor/selection returns to the cell that cused the
change event to occur

AURGH (v. annoying)

any suggestions about what may be happening or how to stop it?

once again, thanks in advance
mark
 
NEVERMIND.... (i found it, it was one of those obvious, stupid mistakes)
(oops - mark)
 
You must log in or register to reply here.

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

selection change macro to go down 1 cell 2
Change event to add button 2
Insert Row also adds formulas and moves cursor 2
Change in cell disabling events 1
Stop Active Cell from Firing Event after Hitting Return 1
Sheet Range Help Required 4
Code for multiple select of cells 16
Changing up to 2 of 3 vals and the 3rd val is automatically Calcul 4

Back
Top