Passing values in Sheet to VBA

G

Guest

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

different value for setting with breakpoint vs regular running code 3
Chart Type - numeric values 3
x-axis scale changes 3
Change default axis category labels 1
Error: unable to set the value property of the series class 2
How to write macro to set the chart scale min/max property? 5
Customize axis scale 2
Change minimumscale with the change event of a combobox 1

Top