Hi, I'm (somewhat sheepishly) experiencing different behaviour from Excel depending on whether I have a stop point set in my macro or not. If I have a stop point it works, if I don't it doesn't.
I suspect it's just me being daft... here is a subsection of code...
If I place a stop point (say on the application.calculate row) in the above code and change the drop list KPI, and simply continue when it hits the stop point it refreshes the screen (picture 1) (note how the drop box at the top says "earned premium" as does the graph heading). If I do the same thing and have no stop point it doesn't (picture 2) (note how the drop box says "gross new bus prem" and the graph still says "earned units").
I know I'm not giving a lot of info here, but I suspect it's one of those problems where the answer is obvious to those who know. Plus the code associated with this small application is significant.
Many thanks for any help that can be offered.
Bookmarks