I am no expert by any means in VBA. I have created some code which does what it should but I have a minor problem
I have a message box displayed with vbOKCancel. On clicking cancel I get returned in a cell 2, if clicking ok 1 is returned. I know that is a result of clicking the button as I tried bypassing the message box and the code worked fine but equally I know clicking cancel it Exits the sub. Is there anyway I can stop the numbers appearing? Or do I just have the 1 or 2 finishing in any blank cell?
It may just be me with the way I have created the code.
Thanks a lot