Copy pasting Rows, but need to Delete any Shapes/Pictures that are within copied rows
 

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....

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....

Copy pasting Rows, but need to Delete any Shapes/Pictures that are
 

I should have included to insert your blank rows first then copy the data.

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....