Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a workbook be prevented from being copied? | Excel Discussion (Misc queries) | |||
Copied formula produces unexpected copied results | New Users to Excel | |||
Time format in a cell getting copied automatically into another ce | Excel Discussion (Misc queries) | |||
cell format changes when formula copied? | Excel Worksheet Functions | |||
format cell to change color when copied | Excel Discussion (Misc queries) |