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