about uscontact usnewsthe teamcareersresourcessite map
   
 
question from Brett
question asked by Brett
date asked 02 November 2001
subject Excel
description How can I copy the cell format along with the cell value? For example cell A1 contains: =indirect(B1) and B1 has the text value "C1" and cell C1 has "Rabbit" in red, Calligrapher 10 font. Cell A1 evaluates to "Rabbit" but it does not copy the font nor the font color to A1.

Microsoft VBScript runtime error '800a01f4'

Variable is undefined: 'sUserName'

/support/showanswer.asp, line 305