Hi Peo

But this method doesn't change the formatting the destination cell when the
formatting in the source cell is changed, no?

I *think* that's what the OP asks for.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Peo Sjoblom" wrote:

If you copy and paste special as link you can carry over the format but it
is a double paste

Copy cell you want to link to, select the cell where you want this to
happen, do editpaste special and select paste link, then do editpaste
special again and this time select formats



--


Regards,


Peo Sjoblom




"Del" wrote in message
...
I am trying to copy a cell from one sheet to another and I use the =
function
but it doesn't copy the same format ie: bold and under line etc.