View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Zeq Zeq is offline
external usenet poster
 
Posts: 1
Default How to add a worksheet from template without duplicate cell styles

I need to add worksheets based on worksheet templates to a workbook. I would
like to use the cell style "normal" as defined in the workbook. However, all
cells in the added worksheet with style "normal" now have style "normal 2"
and will not use the formatting set in the original workbook. Is there any
way to get around this without going through all cells in VBA and changing
the style?