Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to reference to a number/a group of chartobjects?
Hi,
I have several chartobjects - embedded charts - in a worksheet and want with some buttons be able to choose which ones of these to hide and to show. They are named individually already, but I want to be able to refere to a group of them to be hidden/visible. When I recorded an naming procedure I got an R1C1 syntax I didn't like and I don't know how to convert it: ActiveWorkbook.Names.Add Name:="slask", RefersToR1C1:= _ "=""R_Q_FB_31,R_ROI_FB_31,R_CF_FB_31""" Instead I tried to define them as sopm kind of index, but isn't skilled enough to continue with that.: sr = Blad102.ChartObjects(R_Q_FB_31, R_ROI_FB_31, R_CF_FB_31).ShapeRange Maybe it should be as some kind of array, but how? Arrays aren't mentioned as an object to "Name" in "Help". /Kind regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not allow selection of chartobjects ? | Charts and Charting in Excel | |||
Marcowarnings when pasting chartobjects to powerpoint | Charts and Charting in Excel | |||
ChartObjects | Excel Programming | |||
Get the name of a group given the reference to a shape within the group | Excel Programming | |||
Workbook-Events donīt work with ChartObjects | Excel Programming |