Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and pasting values of filtered rows | Excel Discussion (Misc queries) | |||
Add and delete pictures and shapes | Excel Discussion (Misc queries) | |||
blank rows between copied rows | Excel Discussion (Misc queries) | |||
Macro to copy duplicate rows (not delete) | Excel Programming | |||
Copy rows then delete them | Excel Programming |