Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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") |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I represent omit in a list of data in excell? | Excel Discussion (Misc queries) | |||
how to omit printing data highlighted in red | Excel Worksheet Functions | |||
How do I omit hidden data from autosum calculations? | Excel Worksheet Functions | |||
How to omit data in a chart when there are error values? | Charts and Charting in Excel | |||
How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel |