Tom,
Whilst VBA only gives access to the text format of the clipboard directly,
other formats can also be present. Using the VB5/6 Clipboard, you can access
the other formats, some of which a

?vbCFLink
-16640
?vbCFText
1
?vbCFBitmap
2
?vbCFMetafile
3
?vbCFDIB
8
?vbCFPalette
9
?vbCFRTF
-16639
?vbCFFiles
15

Assuming the numbers are consistent, your code is trying to paste the
clipboard data as a metafile.

Playing around with the macro recorder, seems that you can also:
ActiveSheet.PasteSpecial Format:="Picture (Enhanced Metafile)"

NickHK

"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.