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