ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to add a worksheet from template without duplicate cell styles (https://www.excelbanter.com/excel-programming/440422-how-add-worksheet-template-without-duplicate-cell-styles.html)

Zeq

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?


All times are GMT +1. The time now is 07:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com