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

C

Corey

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

Guest

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
 
G

Guest

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

Regards,

OssieMac
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Row based on count and copy range to inserted rows 2
Inserting a Row Range at regular intervals 1
need to delete all rows that are gray 1
Using a macro to delete all blank rows 3
Macro to insert data behind a certain date. 2
copy rows based on conditions and insert them into another sheet... 3
Code to Insert rows and copy formulas 3
Linking spreadsheet where rows are not aligned, but are when portions are hidden 3

Top