how to select ALL named shapes in range
i have named by code an array of shapes on a worksheet.
eg. o1-o80 and og1-og80 and l1-l80 and ig1-ig80 and i1-i80 and p1-p80 and h1-h80 and t1-t80 and e1-e80 and d1-d80 I want to be able to select ALL of these items(Named shapes) so i can move them on the worksheet, but how can i select them all with code? Regards Corey |
how to select ALL named shapes in range
Never mind used:
ActiveSheet.DrawingObjects.Select and de-selected the objects not required. -- Regards Corey "Corey" wrote in message ... i have named by code an array of shapes on a worksheet. eg. o1-o80 and og1-og80 and l1-l80 and ig1-ig80 and i1-i80 and p1-p80 and h1-h80 and t1-t80 and e1-e80 and d1-d80 I want to be able to select ALL of these items(Named shapes) so i can move them on the worksheet, but how can i select them all with code? Regards Corey |
All times are GMT +1. The time now is 02:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com