| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste Special - copy everything except formulas
I have two excel sheets, One sheet is where i do all calculations, have
formulas defined and have conditional formatting defined. But when i copy to the other excel i just dont need to copy formulas, except formulas I need to copy values and special formats. How do i do that. I have tried pastespecial - xlPasteValuesAndNumberFormats, but it does not carry forward conditional formatting. thanks in Advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Paste Special - copy everything except formulas
selection.Copy
With Worksheets("SheetOther").Range("A1") .PasteSpecial xlValues .PasteSpecial xlFormats End With -- Regards, Tom Ogilvy "VishalBade" wrote: I have two excel sheets, One sheet is where i do all calculations, have formulas defined and have conditional formatting defined. But when i copy to the other excel i just dont need to copy formulas, except formulas I need to copy values and special formats. How do i do that. I have tried pastespecial - xlPasteValuesAndNumberFormats, but it does not carry forward conditional formatting. thanks in Advance |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Paste Special - copy everything except formulas
Thanks Very much It worked out.
"Tom Ogilvy" wrote: selection.Copy With Worksheets("SheetOther").Range("A1") .PasteSpecial xlValues .PasteSpecial xlFormats End With -- Regards, Tom Ogilvy "VishalBade" wrote: I have two excel sheets, One sheet is where i do all calculations, have formulas defined and have conditional formatting defined. But when i copy to the other excel i just dont need to copy formulas, except formulas I need to copy values and special formats. How do i do that. I have tried pastespecial - xlPasteValuesAndNumberFormats, but it does not carry forward conditional formatting. thanks in Advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| my paste special function won't let me copy formulas | Excel Worksheet Functions | |||
| Copy column, paste special formulas & number formats doesn't work | Excel Discussion (Misc queries) | |||
| How to copy formulas to a new workbook? Paste Special is different | Excel Worksheet Functions | |||
| Copy and Paste Special (Formulas) pastes cell value if numeric | Excel Discussion (Misc queries) | |||
| Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming | |||
Linear Mode
