No, that is not the intention. What you require can be achieved via EditGo
toSpecial, check Formulas and then copy and paste.

--
Kind regards,

Niek Otten

"bjw10" wrote in message
...
I thought the intention behind Paste Special - Fomulas was to copy across
only the contents of cells that contain a fomula (i.e. begins with an '='
sign) and NOT those that contain a value. Have I got this wrong? It
certainly
doesn't work that way for me since both formulas and values appear in the
paste area.