Hi cyberdude

Only way is to use this (picture link)
http://www.rondebruin.nl/print.htm#non-contiguous


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"cyberdude" wrote in message oups.com...
Hi,

How can I copy the data in and format of a cell on a sheet into a cell
on another sheet provided that the 2 sheets are in the same workbook?

Please note that I need to copy not only the data in a cell but also
the cell's format, for example, the size of the cell and colour of the
text inside the cell into another cell.

Thank you.

David