Carts and Acticesheet.Range
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 C2:D10 on the active worksheet, you can use any of the
following examples:
ActiveSheet.Range(Cells(2, 3), Cells(10, 4)).Select
ActiveSheet.Range("C2:D10").Select
--ActiveSheet.Range("C2", "D10").Select
Also are there any different problems when setting the other chart
paramenters?
Thxs
--
RickLM
|