View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Copy pasting Rows, but need to Delete any Shapes/Pictures that are

Try this and see if it overcomes your problem:-

Copy, Paste Special-Formulas and Number formats.

If you have other formats to be pasted, then simply past special again to
the same destination and select formats. You can Past Special as many times
as you like selecting different options to paste without having to reselect
and copy the original.

Regards,

OssieMac

"Corey" wrote:

I am copying rows 1-12 and inserting them above the current (moveing previous down)
However as there is sometimes a picture in that range of rows, when i copy/insert the new rows,
the picture also is inserted.
Is there a way to delete any picture/shap within the range of rows copied, without deleting the
other pictures further down ?

Corey....