Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I recall several discussions with different people. The specifics are vague,
but the nagging feeling that I shouldn't do it that way are pretty strong. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Peter T" <peter_t@discussions wrote in message ... I've gotten into the habit of looping with a counter: For iItem = 1 to blah.Shapes("Group 7").GroupItems.Count Set shp = blah.Shapes("Group 7").GroupItems(iItems) because sometimes it seems that For Each misses one or two items. Indeed it can (miss items) or worse error (eg for each series in certain chart types). I vaguely recall we discussed this before a while ago. Regards, Peter T |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Assign a text to a rectangle | Excel Discussion (Misc queries) | |||
Text Box vs. rectangle, what is the difference? | Excel Discussion (Misc queries) | |||
text does not update in rectangle box | Excel Programming | |||
Change text in rectangle shape | Excel Programming | |||
Add text to a rectangle in VBA | Excel Programming |