Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
Multiple data on 2 carts | Charts and Charting in Excel | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
Range.Find returns cell outside of range when range set to single cell | Excel Programming | |||
how to? set my range= my UDF argument (range vs. value in range) [advanced?] | Excel Programming |