Display cells on screen that have error

Question

I have an error handler setup that allows the user to update incorrect data when the Macro detects an error. The problem is the macro is checking a large volume of data and the user can't see the cell in question I'm asking them to update. What can I add to this error handler to allow the user see the cell on screen before they input the correct result into the inpput box? Thanks.

ErrPrice:
rngEachValue.value = InputBox ("Input correct Price here")

Answer 1

You can highlight the cell with:

rngEachValue.Activate

This way, the cell will be selected and surrounded. Alternatively, if you use rngEachValue.Copyafterwards, you'll even see the "moving" selection...