Copying the data in and format of a cell to another cell
 

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

Copying the data in and format of a cell to another cell
 

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