Method Select Fail when trying to edit shapes in a worksheet

[jeff_kaufman]

See code below.

Please Login or Register  to view this content.

This is the error I get:

Run-time error '-2147467259 (80004005)':
Method 'Select of object 'Shape" failed


Suggestions?

Thanks

Jeff

[Norie]

Jeff

Don't use Select.

[jeff_kaufman]

So... just remove that part of the code or use a different method to apply changes to all the shapes in my worksheet?

[jeff_kaufman]

Yep -that worked... thanks - why is it only the easiest solutions are the most difficult to find? Sheesh...

[Norie]

Removing the Select should work as selecting isn't needed.