When stepping through, code doesn't stop after this "paste" command...why?

[Artik]

in some cases, we are only charting 3 years of data (rather than 5 years, as tested on here).

This makes that the whole concept had to change.

I'm hoping (...) that you'll return to this post and see my latest request for assistance/modification.

Writing the code does not last as long as its execution. It lasts definitely shorter. But figuring out how the code is supposed to work, it's been taking forever.


I spent many hours on tests and I think I finally discovered why the code execution sometimes stops. The code works too fast, so sometimes it will not be able to copy the range from the source (and the clipboard is empty). And when the clipboard is empty, you can not paste anything. These two places in the code cause errors.


The new version should cope with errors. In two sensitive procedures, I put error handling. I also changed the code's operation philosophy. In one combo I create two images (separately chart and table), center them in relation to each other, and then group them and create a new image from the group. This all happens when the "Please wait" text is displayed.


Let me know if everything works without errors.


I think that now you will not be a hero, but Superman.



Artik