-
March 12th, 2003 04:25 AM
#1
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Bookmarks