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

Tom.

"Tom Ogilvy" wrote:

expression.PasteSpecial(Paste, Operation, SkipBlanks, Transpose)

the xlPasteSpecialSubtract would be an argument to the Operation


expression.PasteSpecial(Paste, Operation:=xlPasteSpecialSubtract,
SkipBlanks, Transpose)

As I said, that is for the range version of paste special. The example you
showed is not for a range.

--
Regards,
Tom Ogilvy


"mr tom" <mr-tom at mr-tom.co.uk.(donotspam) wrote in message
...
Interesting.

Experimentally, it seems it must be paste special values. It certainly
doesn't perform the subtract function.

Goodness knows how we're supposed to know that!

Thanks so much for your help.

Tom.

"Jim Rech" wrote:

If you have Excel open the VBE. Then open the Object Browser (press F2).
In the Classes control on the left scroll down to XlPasteType. In the
Members pane you'll see all the enumerations. As you select each one its
number value appears in the bottom of the Object Browser. I don't see
any
that are '3'.

--
Jim
"mr tom" <mr-tom at mr-tom.co.uk.(donotspam) wrote in message
...
| Current Code:
|
| ActiveSheet.PasteSpecial Format:=3
|
| This is somebody else's code.
|
| Just a quick question about the Format:=3
|
| Does it PasteSpecial as Values? Or does it do something else?
|
| Cheers,
|
| Tom.