Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
colour and value transfer
pastespecial xlAllValues pastes both format and value
you could just paste special the format to leave the values unchanged but to render the format. Dim x As Range x.PasteSpecial xlPasteAll x.PasteSpecial xlPasteFormats Patrick Molloy Microsoft Excel MVP -----Original Message----- Thanks for the response to my last posting. This one I hope is even simpler. How can I cut and paste the colour formatting of a cell and its value? The value is generated by a formula so normal cut and paste doesn't work and a paste special value transfer removes the colour. Any ideas? Thanks, Bob . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
colour and value transfer
I think Patrick meant you should paste values, then paste formats
Dim x As Range x.PasteSpecial xlPasteValues x.PasteSpecial xlPasteFormats There is no xlAllValues and xlPasteAll is the same as a normal copy and paste XlPasteType constants: xlPasteAll, xlPasteFormulas, xlPasteValues, xlPasteFormats, xlPasteNotes, or xlPasteAllExceptBorders. -- Regards, Tom Ogilvy "Patrick Molloy" wrote in message ... pastespecial xlAllValues pastes both format and value you could just paste special the format to leave the values unchanged but to render the format. Dim x As Range x.PasteSpecial xlPasteAll x.PasteSpecial xlPasteFormats Patrick Molloy Microsoft Excel MVP -----Original Message----- Thanks for the response to my last posting. This one I hope is even simpler. How can I cut and paste the colour formatting of a cell and its value? The value is generated by a formula so normal cut and paste doesn't work and a paste special value transfer removes the colour. Any ideas? Thanks, Bob . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
colour and value transfer
Thanks Tom,
You've helped me out once again! -----Original Message----- I think Patrick meant you should paste values, then paste formats Dim x As Range x.PasteSpecial xlPasteValues x.PasteSpecial xlPasteFormats There is no xlAllValues and xlPasteAll is the same as a normal copy and paste XlPasteType constants: xlPasteAll, xlPasteFormulas, xlPasteValues, xlPasteFormats, xlPasteNotes, or xlPasteAllExceptBorders. -- Regards, Tom Ogilvy "Patrick Molloy" wrote in message ... pastespecial xlAllValues pastes both format and value you could just paste special the format to leave the values unchanged but to render the format. Dim x As Range x.PasteSpecial xlPasteAll x.PasteSpecial xlPasteFormats Patrick Molloy Microsoft Excel MVP -----Original Message----- Thanks for the response to my last posting. This one I hope is even simpler. How can I cut and paste the colour formatting of a cell and its value? The value is generated by a formula so normal cut and paste doesn't work and a paste special value transfer removes the colour. Any ideas? Thanks, Bob . . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
colour and value transfer
Thanks Tom,
You've helped me out once again! -----Original Message----- I think Patrick meant you should paste values, then paste formats Dim x As Range x.PasteSpecial xlPasteValues x.PasteSpecial xlPasteFormats There is no xlAllValues and xlPasteAll is the same as a normal copy and paste XlPasteType constants: xlPasteAll, xlPasteFormulas, xlPasteValues, xlPasteFormats, xlPasteNotes, or xlPasteAllExceptBorders. -- Regards, Tom Ogilvy "Patrick Molloy" wrote in message ... pastespecial xlAllValues pastes both format and value you could just paste special the format to leave the values unchanged but to render the format. Dim x As Range x.PasteSpecial xlPasteAll x.PasteSpecial xlPasteFormats Patrick Molloy Microsoft Excel MVP -----Original Message----- Thanks for the response to my last posting. This one I hope is even simpler. How can I cut and paste the colour formatting of a cell and its value? The value is generated by a formula so normal cut and paste doesn't work and a paste special value transfer removes the colour. Any ideas? Thanks, Bob . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you transfer cell colour with value | Excel Worksheet Functions | |||
How can colour of cell shading be fixed to one colour | Excel Discussion (Misc queries) | |||
How do I save new colour schemes for graphs in the colour template | Charts and Charting in Excel | |||
change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
Text in Blue colour, but print in black colour | Excel Worksheet Functions |