J
Jim Kelly
Hi All!
I have a macro that runs through however many worksheets a workbook
has and charts the data from each worksheet into a final "charts"
worksheet. I have about 6 or 7 charts showing, but you can scroll
through all 40 if you wish. When it runs it always finishes with the
scroll bar at the bottom, showing the last group of charts. If you
then scroll up to view any of the upper charts, then re-run the macro,
the very last chart does not finish formatting. Then if you scroll up
or down, it goes away but it is correctly formatted at the bottom of
the list (where it belongs). It's as if the screen refreshed one step
too early? I use screenupdating at the very end so one would think
that would do the trick, right?
But if you put the scrollbar back at the bottom and re-run the macro,
it does fine.
Thank you,
Jim
I have a macro that runs through however many worksheets a workbook
has and charts the data from each worksheet into a final "charts"
worksheet. I have about 6 or 7 charts showing, but you can scroll
through all 40 if you wish. When it runs it always finishes with the
scroll bar at the bottom, showing the last group of charts. If you
then scroll up to view any of the upper charts, then re-run the macro,
the very last chart does not finish formatting. Then if you scroll up
or down, it goes away but it is correctly formatted at the bottom of
the list (where it belongs). It's as if the screen refreshed one step
too early? I use screenupdating at the very end so one would think
that would do the trick, right?
But if you put the scrollbar back at the bottom and re-run the macro,
it does fine.
Thank you,
Jim