-
Group shapes in Excel
Hi,
I've drawn a lot of shapes on a excel worksheet. Now I want to group
them, but not all of them. I think I need to use the group
command
Sheet(1).Shapes.Range(Array(1, 2, 3, 6).Group
I now want to create the array outside this function,
because there are not always the same shapenumbers to be
included in the group.
So something like this
for a = 1 to shapes.count
if shapeinclude somearray = somearray + a
next
But I can't get it to work. How can I create an array
that's accepted in the group method.
Thanx in advance