Hello!
I'm new to this vbaexcel stuff so please pardon the simplicity of this...and thanks beforehand to anyone who even reads this!
I've tried using this code here to label my scatter plot:
http://support.microsoft.com/kb/213750#appliesto
but everytime I run it again to adjust for changes in my data it gives me the following error:
Run-time Error '91'
Object variable or With block variable not set
The line that highlights in the debug window is: xVals = ActiveChart.SeriesCollection(1).Formula
I looked at the definition online of this error but I'm not sure what the object is in the code...
Any ideas why it's not working?
I know an add-in exists but I don't want to use it.
Thanks again! Any help is much appreciated .
Bookmarks