Passing values in Sheet to VBA

J

Jonathan

Hi,
I'm trying to pass the .MinimumScale value from a range on my spreadsheet to
a chart which is created when the Macro is run from the spreadsheet.
The macro is halted by an error message 'Run-time error '1004': Unable to
set the MinimumScale property of the Axis class'.
When I 'Debug' and F8/Step-into the code however, it sets the value as I'd
intended and completes the rest of the code without any problems - In fact
running the code using the 'Step Into' function all the way completes the
program without any hitches.
Please could somebody tell me what I'm missing? It's probably really obvious
and I apologise for that in advance.
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart Type - numeric values 3
VBA Assigning cell value to variable giving runtime error 3
Error: unable to set the value property of the series class 2
Workbooks(WorkbookName).Activate Failure 2
Problems with setting .Values with vba 3
Copy/Paste Picture Fails - then works 2
Cannot assign a range to seriecollection values 3
Change minimumscale with the change event of a combobox 1

Top