March 12th, 2003 04:25 AM
Group shapes in Excel
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
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
But I can't get it to work. How can I create an array
that's accepted in the group method.
Thanx in advance
Click Here to Expand Forum to Full Width