About Us

Don Guillett

Glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gary" wrote in message
...
A most excellent answer. I will never forget the on error resume next
solution.
--
To learn is to live.

"Don Guillett" wrote:

You fail to show your code but
on error resume next
or
sub delshps()
for each sh in activeworksheet.shapes
sh.delete
next sh
end sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gary" wrote in message
...
I have some code that deletes shapes by selecting individual shapes then
deleting them prior to sending document in an email to another
division.
Unfortunately, I found out today that if the shape somehow was deleted,
the
macro blows up. I need something like:

If shape exists then
select shape
delete shape
end if

I can't figure out how to determine if the shape exists. Another
possibility, I suppose, is to check for an error on delete, but I'm not
sure
how to do this.

Thanks,
Gary
--
To learn is to live.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel document with shapes on it but the shapes do not print	[email protected]	Excel Worksheet Functions	2	October 22nd 09 06:17 PM
Naming Auto Shapes and Creating new Shapes	AL2000	Excel Discussion (Misc queries)	3	September 10th 07 04:12 AM
When drawing shapes in excel the shapes keep disappearing	Tape	Excel Discussion (Misc queries)	1	October 6th 06 04:23 PM
How can i get more 3D shapes for Auto shapes in excel?	Ajey	Excel Discussion (Misc queries)	0	March 3rd 05 09:53 AM
How can i get more 3D shapes for Auto shapes in excel?	Ajey	Excel Discussion (Misc queries)	0	March 3rd 05 09:53 AM