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

.PasteSpecial(xlPasteValuesAndNumberFormats)

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

.PasteSpecial(xlPasteFormats)

Brilliant - thanks very much for solving that for me.