| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group drawing objects in VBA
Thank you. A problem is that there are many other shapes on the sheet
which I don't want in this group, so I need to collect these names in an array as they are drawn. Since the Shapes.Range(Array...) wants string names and I don't know how many there will be, I'm confused about how to dim the array, redim it when I know how many lines there will be, and use it to select the group of lines. I'm probably not doing this the best way. Thanks again. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I KEEP DRAWING OBJECTS ANCHORED? | Excel Discussion (Misc queries) | |||
| cannot group columns - get "cannot shift objects off sheet" help! | Excel Worksheet Functions | |||
| cannot group columns - get "cannot shift objects off sheet" help! | Excel Worksheet Functions | |||
| how can I select multiple drawing objects at once | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Threaded Mode
