retain cell formatting
 

Hi all - is there any way to retain cell formatting, ie cell a1 is 10
bold, cell a2 is 20 bold, i want to copy a2 into a1 but make it appear
10 bold. thanks


--
bob777
------------------------------------------------------------------------
bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504
View this thread: http://www.excelforum.com/showthread...hreadid=481000

retain cell formatting
 

Try CopyPaste SpecialValues

Does this work for you?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=481000