As quickly as you can record yourself doing the copy then Paste
SpecialPaste links and Paste SpecialFormats.


Gord Dibben MS Excel MVP

On Fri, 29 Aug 2008 15:20:00 -0700, sirjibby
wrote:

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