Thanks for the help folks. I know just enough VBA to be dangerous at a
cocktail party, but nothing ventured nothing gained!

"Norman Jones" wrote:

Hi Dave,

Thank you for the additional information.

---
Regards,
Norman



"Dave Peterson" wrote in message
...
I am aware that a limit exists when working with shapes/objects.

But I'm not sure what that limit is (or if it's a hard limit--or if it
depends
on what's in use (memory??)).

I do know that the single line fails when there are lots (and quite a few
people
have lots of shapes in worksheets based on posts around here).

I've never seen your looping code fail.

I'm not sure I understand the second portion. Since it's a one liner, I'm
guessing that it's based on the number of objects, since there's only one
pass
(did that make sense???).