Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shapes Range Array
Excel 2002 VBA. I am drawing some lines on a worksheet. After I've
finished drawing them, I want to group them together. Can I populate an array as I draw them, then when I'm done drawing them, use the array to group them? What kind of array should I use? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shapes Range Array
You can simply group them as is done in Visio. Select the first line, then hold the CTRL key and select the other required lines, then Rightmouse, Grouping, Group. -- Bubb Wrote: Excel 2002 VBA. I am drawing some lines on a worksheet. After I've finished drawing them, I want to group them together. Can I populate an array as I draw them, then when I'm done drawing them, use the array to group them? What kind of array should I use? -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=531583 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Question to Bob Phillips (or whoever...) | Excel Worksheet Functions | |||
Match function...random search? | Excel Worksheet Functions | |||
Changing a range of an array in a SUMPRODUCT formula gives a #N/A error | Excel Discussion (Misc queries) | |||
Define a range based on another named range | Excel Worksheet Functions |