Hi Everyone.
I would need a pieace of simple code which will be trigered by pressing Calculate Now button (manual calculation).
What I need after that is a message box with 2 conditions:
1. "Calculation successful" (if there is no cells with error on that sheet)
2. "Calculation unsuccessful" (if there is even one cell with error value - N/A, #Value etc.)
I believe this is possible since I already have message box after calculation is done, but I miss check on error values after that.
Thanks in advance
I would need a pieace of simple code which will be trigered by pressing Calculate Now button (manual calculation).
What I need after that is a message box with 2 conditions:
1. "Calculation successful" (if there is no cells with error on that sheet)
2. "Calculation unsuccessful" (if there is even one cell with error value - N/A, #Value etc.)
I believe this is possible since I already have message box after calculation is done, but I miss check on error values after that.
Thanks in advance