why a delay when entering data

[Guest]

new in 2003, I am getting a delay when entering data before the cursor jumps
to the next cell. It seems to be related to iteration, but iteration didn't
produce this effect in 2000. Anyone know why and how to prevent the delay?

 

[Dave Peterson]

I don't know of a reason iteration would affect this.

But my first though was that you had a worksheet_change event firing that was
calling itself recursively until excel gave up trying.

If you open the workbook with macros disabled, do you have the same delay?

If no, try rightclicking on the worksheet tab and selecting view code. (If the
project is protected, you may need a password to see this.)

If you see code there, you may have found the problem. If you have trouble
fixing it, copy the code into a followup message. (Not the workbook!)

I'm sure someone will be able to help.