Copy Macro not copying custom formats?

[markvdh]

Hi Guys

I wonder if someone might be able to assist. I have a workbook, with a macro (which one of the members helped me with) to copy the existing page and change the sheet name. It all works well, except, on the new sheet resulting from the copy, the custom formats have not been copied?

Appreciate some help. Workbook attached.

[romperstomper]

What formats are you referring to? The copy looks exactly the same to me (as it should since you copied the whole sheet)

[markvdh]

I'm referring to the custom formating of, for example, the negative values in cell D11 goes from a format of (458,685) to -458,685 or from custom format ##,##0_);(#,##0) to custom format #,##0;-#,##0. Maybe I'm missing something here?

[romperstomper]

OK, I see that in 2003 (in 2010 it works fine). Try this:

Please Login or Register  to view this content.

[markvdh]

That works fine. Thank you