I have a reference in my workbook which copies from cells in sheet2 to
cells in sheet1. Is there anyway (preferably without a macro!) that
will also copy the formats of the cell without doing it manually every
time. I.e it just copies the cell exactly each time.

Thanks


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=566559