I have a question about the VBA code that I wrote.
I use the task handler to open the excel file and the VBA code run as the file opens. but some time the debug/end window will appear (occasionally) and if I click “debug” it will send me to the code itself if I manually click f5 or f8 it runs no problem. And if I manually run my vba code no issue as well.
Can some one help me with figure out what is the issue??
here is part of code it stops me at. Paste part
Worksheets("Report").ChartObjects("Chart 3").Chart.ChartArea.Copy With Worksheets("Copy") .Activate .Range("K2").Select .Pictures.Paste