To delete everything on a worksheet, we can write:

Cells.Delete

Is there a similar command for deleting all the pictures on the worksheet?

Thanks!

Hi Shatin,

ActiveSheet.Shapes.SelectAll

Ed Ferrero
http://edferrero.m6.net/

To delete everything on a worksheet, we can write:

Cells.Delete

Is there a similar command for deleting all the pictures on the worksheet?

Thanks!

To delete pictures only, but not other shapes, try

ActiveSheet.Pictures.Delete

Regards,
Peter T


"Shatin" wrote in message
...
To delete everything on a worksheet, we can write:

Cells.Delete

Is there a similar command for deleting all the pictures on the worksheet?

Thanks!

Peter,

Exactly what I am looking for! Thanks so much.

"Peter T" <peter_t@discussions wrote in message
...
To delete pictures only, but not other shapes, try

ActiveSheet.Pictures.Delete

Regards,
Peter T


"Shatin" wrote in message
...
To delete everything on a worksheet, we can write:

Cells.Delete

Is there a similar command for deleting all the pictures on the
worksheet?

Thanks!