Am having problem with setting Active.Range in chart Data Range Excel 2000
Error:
Formual you typed contains and error
='Activesheet.Range’!("$A$114:$M$116�,"$A$119:$M$119").select

I followed existing format for setting up chart but sub'ed above based on
following for MS KB website.
How to Select a Range of Cells on the Active Worksheet
To select the range C210 on the active worksheet, you can use any of the
following examples:
ActiveSheet.Range(Cells(2, 3), Cells(10, 4)).Select

ActiveSheet.Range("C210").Select

-->ActiveSheet.Range("C2", "D10").Select

Also are there any different problems when setting the other chart
paramenters?
Thxs
--
RickLM

If you're not sure what's going to work, type the command into the Immediate
Window and press Enter, then see what Excel did.

Activesheet.Range("$A$114:$M$116","$A$119:$M$119").select

selected A114:M119, while

Activesheet.Range("$A$114:$M$116,$A$119:$M$119").select

selected A114:M116 and A119:M119

You should post more than one line of code so we can see what you're up to.
There's usually a better way than selecting ranges.

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



"RickLM" <(E-Mail Removed).(donotspam)> wrote in message
news:CDF4A46F-560F-4B6A-89F3-(E-Mail Removed)...
> Am having problem with setting Active.Range in chart Data Range Excel 2000
> Error:
> Formual you typed contains and error
> ='Activesheet.Range'!("$A$114:$M$116","$A$119:$M$119").select
>
> I followed existing format for setting up chart but sub'ed above based on
> following for MS KB website.
> How to Select a Range of Cells on the Active Worksheet
> To select the range C210 on the active worksheet, you can use any of the
> following examples:
> ActiveSheet.Range(Cells(2, 3), Cells(10, 4)).Select
>
> ActiveSheet.Range("C210").Select
>
> -->ActiveSheet.Range("C2", "D10").Select
>
> Also are there any different problems when setting the other chart
> paramenters?
> Thxs
> --
> RickLM