Hi Luke,

I know that this might sound like an over simplification but l have
had similiar problems in the past which l have found to be the result
of over zealous use of the 'esc' key to interupt your VBA code.

The keystrokes are retained in memory so when you reset your project
it will fail again & again until all the 'esc' are used. This can
usually be overcome by rebooting your PC. Closing Excel does not do
it.

I have also occasionally found that my desktop PC keyboard ends up
with sticky keys (odd bit of food in it etc) and if this is the 'esc'
key the problem you describe manifests itself.

Hope this is of use to you. As l say l have had this problem exactly
as described and it took me ages to detect.

Regards

Michael Beckinsale