Strange Macro behaviour

Is calculation set to Automatic in the workbook?

Look in the bottom left hand corner of the picture. It says "calculate" which means Calculation Mode is set to manual. Set it to Automatic.

That might be related to your macro. A picture of a macro enabled workbook isn't an awful lot of use in diagnosing the cause of a problem ... although, in this case, one of the symptoms is obvious. A sample workbook and/or code is more help in determining the root cause of the problem.

Regards, TMS

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.