There are two different PasteSpecial methods.

The one in the code you cite is the Worksheet method, which takes the
format parameter, which VBA Help defines as

Optional Variant. A string that specifies the Clipboard format of the
data.

Based on a minimum of experimentation, the format of the data that is
pasted in when a cell with a formula is copied and Format:=3 is used,
the result is that the displayed value is pasted. Format:=1 also pastes
the result, while Format:=2 pastes the formula.

It has nothing to do with xlPasteType, which is associated with the
Range version of PasteSpecial (specifically, the Paste argument).

Your speculation about Paste Special Values isn't warranted - that only
applies to the Range version.

Your speculation about the Subtract function isn't warranted either,
that also only applies to the Range version, and depends on the
Operation argument.

In article ,
mr tom <mr-tom at mr-tom.co.uk.(donotspam) wrote:

Sorry - you've completely lost me, but I really do appreciate you taking the
time to reply :-)