Why my cell format is not copied when I copied workbook?
 

I copied one workbook to another workbook using the following code..

Sub Test()

Dim Nwb As Workbook
Dim i As Integer

Application.ScreenUpdating = False
Sheets(Array("alpha", "bravo", "charlie", "delta")).Copy

Set Nwb = ActiveWorkbook

Nwb.Sheets.Select
Cells.Select
Selection.Interior.ColorIndex = xlNone

Application.ScreenUpdating = True

End Sub

But why is it that the some of my customised cell format in my original
workbook does not get copied over to the new workbook.
The cell format that does not get copied is such:
#,##0_);[Red](#,##0)

This means that a negative number will be shown in red and in brackets.
Though negative numbers in the new workbook are shown in red, they are
not shown in brackets. Anyone care to enlighten me on this?


---
Message posted from http://www.ExcelForum.com/