colour and value transfer

[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

 

[Tom Ogilvy]

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.

 

[Bob]

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





.

 

[Bob]

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





.