Hi Everyone
I've got a bit of a weird problem - I've written some code to extract a trendline formula from a newly created graph and it works perfectly if, and only if, I step through it line by line. If I run the code it will sometimes return a null string instead of the formula - this is really annoying as I need to get the trendline formula from over 200 graphs in 200 files (that bit worked out with help from these forums).
During my troubleshooting, I've simplified and simplified the code in terms of functions being called and subroutines etc but even with just the below, it's still really flakey.
What I have is:
The graphs always get added, even if the formulas don't.Please Login or Register to view this content.
The headings in G2 and G3 always get added, even if the formulas don't.
I've tried outputting to a variable, instead of a cell value, and that doesn't always work.
I've tried outputting to a msgbox, instead of a cell value, and that doesn't always work.
The draw_a_graph sub-routine is called from
I have uploaded 5 of the files to be graphed reports.zip.Please Login or Register to view this content.
I'm running Excel 2010 on Windows 7.
I've searched all sorts of forums and help files and google and I just can't make heads or tails of what's happening - any thoughts gratefully accepted!
All the best
David
Bookmarks