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