Cannot be done.

Do a second pass and select "Formats"

i.e. paste specialpaste link

then

paste specialformats


Gord Dibben MS Excel MVP

On Tue, 24 Jul 2007 14:02:02 -0700, jrebello
wrote:

When I do 'paste special', 'paste link' the formatting doesn't transfer with
it. I want the fomatting to transfer with it.