Paste Special Values and Formats

Hi,

I'm using the following bit of code:

.PasteSpecial Paste:=xlPasteValues

to ask a macro to Paste Special (Values) - but how would I ask it to Paste Special (Formats) as well?

Many Thanks
Rob

Please Login or Register  to view this content.

Or follow the paste values with another line of code to paste formats

Please Login or Register  to view this content.

Brilliant - thanks very much for solving that for me.