Sure, but might need to cater for other people's habits!

Regards,
Peter T

"Jon Peltier" wrote in message
...
I remember now the discussion about punctuation in object names, and I am
glad I never got into that habit.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Peter T" <peter_t@discussions wrote in message
...
Hi Jon,

One problem using For Each at the DrawingObject level (ChartObject,
Rectangle etc) is if the object's name includes punctuation it's not
picked
up, eg
<snip

Regards,
Peter T



"Jon Peltier" wrote in message
...
Peter -

I invariably use

For each chtObj in ws.ChartObjects

What kind of problems have you encountered with this approach?

- Jon
-------