PC Review


Reply
Thread Tools Rate Thread

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

 
 
Corey
Guest
Posts: n/a
 
      1st Aug 2007
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 With Quote
 
 
 
 
=?Utf-8?B?T3NzaWVNYWM=?=
Guest
Posts: n/a
 
      1st Aug 2007
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....
>
>
>

 
Reply With Quote
 
=?Utf-8?B?T3NzaWVNYWM=?=
Guest
Posts: n/a
 
      1st Aug 2007
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy and pasting values of filtered rows Jammings Microsoft Excel Misc 1 5th Aug 2009 06:45 PM
Code to delete shapes in copied sheets nelly Microsoft Excel Programming 2 27th Jul 2009 02:25 PM
help with syntax for copy and pasting rows across sheets haileybury Microsoft Excel Programming 4 30th Sep 2008 01:58 PM
blank rows between copied rows =?Utf-8?B?QXJpZg==?= Microsoft Excel Misc 2 5th May 2006 12:18 PM
Copy rows then delete them Richard Microsoft Excel Programming 3 3rd Dec 2003 02:24 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:14 AM.