Copy format of cell from other worksheet
Ok thanks for letting me know. Could you possibly explain quickly how I would
get a macro to do that?
"Dave Peterson" wrote:
Formulas don't return this kind of formatting. They return values.
You could copy|paste or have a macro do it.
sirjibby wrote:
When you tell a cell to display the contents of a cell from another worksheet
(eg. if in a cell from Sheet2 I put the formula ='Sheet1'!A1), how do you
also get it to use the formatting of that cell?
Thanks in advance for looking!
--
Dave Peterson
|