Simple Macro crashes excel

Hi

I have created a basic macro to increase the value of the D2 cell contents by 1 every time it is run - as below:

Please Login or Register  to view this content.

However, every time I run it, it crashes excel.

I have tried running this macro in a workbook with nothing else in it as well as my master workbook which has other macros and calculations in it.

I am able to run much more complex macros without crashing excel - any thoughts/suggestions?

Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 6)

Maybe that the code is causing a forever loop - try:

Please Login or Register  to view this content.

Do you have any add-ins?
Are you sure the book was a empty workbook aside from adding this bit of code to it?

What version of excel are you on?
entering that in your details may help ppl find solutions for you.