Using Named Range to Set DataSource in Chart
Sounds like there's something wrong with your named range -
MsgBox ActiveWorkbook.Names("myNamedRange").RefersTo
MsgBox Range("myNamedRange").Address(, , , True)
Regards,
Peter T
"Dyl" wrote in message
oups.com...
Peter,
Thanks for your help. Unfortunately this still does not work. I get
the following error.
Run-tine error '1004'
Method 'Range of object '_Global falied
I also tried to set the range in the same procedure, but I still got
the same error. (I had been getting the value from a function earlier)
I'll keep trying. Thanks again for your help!
|