colour and value transfer

  • Thread starter Thread starter Patrick Molloy
  • Start date Start date
P

Patrick Molloy

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
 
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.
 
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





.
 
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





.
 
Back
Top