Passing values in Sheet to VBA
 

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


--
Jonathan

Passing values in Sheet to VBA
 

You left out two details:

1. Excel version
2. Problematic code

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Jonathan" wrote in message
...
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


--
Jonathan