Paul_Hossler


Now I'm sure that the code itself is NOT the problem.


There's something going on with the Worksheet itself that I can't isolate.
I've come to this conclusion because if I create a blank sheet and run all of the different versions of the code that has been suggested, as well as my original code, the new sheet performs as expected.
No Errors, No Problems.
However, when I run all of the code that we've put forward, a problem arises.
Either the ActiveCell returned is NOT the one that was selected, or it randomly makes the ActiveCell the last ActiveCell that was used.

Even when I copy the sheet to a new workbook, the problems arise.
If I run the macro or step through it using F8, everything works as intended, so there's something going on with the click of the Button that's causing the problem.
M question is: How do you investigate random behavior on a worksheet, probably caused by clicking the Button.