Hi Merjet

....of course, specify the sheet, its so simple when you look it, isnt it! i
apologise for my dim-wittedness.

that now works fine coming from the cell refs, so it is basically done.
thank you.


i am still curious, however, as to how i would successfully get the number
from the textbox of the spinbutton into an integer for the macro to read for
the plot & legend scales. I have tried the CInt() thing & its not happening.


Many thanks again

jb

"merjet" wrote:

Given that the chart is on a sheet of its own and your code assumes it
is the ActiveSheet, using Range("A1") to adjust a chart property won't
work (gives me a run-time error 1004). You need to qualify it, e.g.
Sheets("Sheet1").Range("A1").

Could you please explain how i would convert the
textbox value from text to number?

Assign it to a variable declared as a number (Integer, Long, Single,
Double) or use a convert function CInt(), CLng(), CSng(), CDbl(),
Val().

Merjet