Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting most of very many programmatically
I've been struggling with this for days, and this group is my last hope.
I need to select a large subset of autoshapes from a larger set of the autoshapes in a worksheet. I tried recording a macro, to see how the selection process gets coded by Excel. But the business end of the macro is: ActiveSheets.Shapes.Range(Array(...)).select where ... is a list of variants containing the name-property values of the autoshapes, separated by commas. I can fill an array of variants with the name-property values of interest. But for the life of me I can't get the array of variants into the argument field of the Array function. Is there some simple way of selecting many shapes from a larger set of shapes and doing so programmatically? I just don't have much hair left that I can pull out any more. Tony Rizzo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting Embedded charts in Active Sheets programmatically | Charts and Charting in Excel | |||
How do I programmatically specify a range. | Excel Programming | |||
delete row programmatically | Excel Programming | |||
Programmatically Add Reference` | Excel Programming | |||
Selecting Rows Programmatically | Excel Programming |