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 |
Carts and Acticesheet.Range
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").s elect 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" .(donotspam) wrote in message ... 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$1 19").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 |
All times are GMT +1. The time now is 09:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com