Copying formatted cells

[Pat S]

I am trying to copy a range of formatted cells with text
in them from one sheet to another. When I copy, it paste
the text but not the cell format. It seems everyone has
that problem. Does anyone know how to get them format to
copy also???

Thanks

Bob

 

[Nicky]

try edit past_special and click on the option button labelled formats