Paste and Omit Certain data
 

Good Morning,

I have a macro that copies one page of data to another by pasting the
values. The original copy page also includes text boxes and clip art on it.
I'm looking to only capture the Excel cell contents in the copy paste process
vs. the clip art and the text boxes.

Since this is pasting to a Template that is formatted exactly the same as
the sheet pasting to it, pasting over the text boxes multiple times ends up
muddying the original text. All I really need is for the cell data to paste
- not the clip art and text boxes.

Any ideas how to instruct the line of data to capture just the one and not
the other?

Thank you - Roger



WB1.ActiveSheet.Range("B2:R62").Copy Destination:=ActiveSheet.Range("B2:R62")

Paste and Omit Certain data
 

Hello,

Adding the below right before you copy line might just do the trick.

Jenny B.

Application.CopyObjectsWithCells = False

"Roger" wrote:

Good Morning,

I have a macro that copies one page of data to another by pasting the
values. The original copy page also includes text boxes and clip art on it.
I'm looking to only capture the Excel cell contents in the copy paste process
vs. the clip art and the text boxes.

Since this is pasting to a Template that is formatted exactly the same as
the sheet pasting to it, pasting over the text boxes multiple times ends up
muddying the original text. All I really need is for the cell data to paste
- not the clip art and text boxes.

Any ideas how to instruct the line of data to capture just the one and not
the other?

Thank you - Roger



WB1.ActiveSheet.Range("B2:R62").Copy Destination:=ActiveSheet.Range("B2:R62")