How to add a worksheet from template without duplicate cell styles

Zeq

Guest

Posts: n/a

9th Mar 2010

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?

« RE: reading data from .xls file | Custom XLAM tab not showing up when excel is opened from word »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
some unknown Cell styles are shown in cell styles	Vaibhav Dhawade	Microsoft Excel Worksheet Functions	0	6th Mar 2010 05:11 AM
Duplicate cell information from one worksheet to another:	Velveteen Lion	Microsoft Excel Worksheet Functions	1	1st Dec 2008 07:24 AM
Excel Cell Styles - Quick Styles?	=?Utf-8?B?RGVhbkBEQ0Y=?=	Microsoft Excel Misc	0	15th Nov 2007 10:40 PM
Unwanted duplicate styles created	=?Utf-8?B?UGF0cmljayBTZXVycmU=?=	Microsoft Excel Programming	0	2nd Dec 2005 03:06 PM
HOW DUPLICATE TEXT ON ALL PAGES OF WORKSHEET FROM ONE CELL	=?Utf-8?B?U2FtYW50aGEgU3RldmVuc29u?=	Microsoft Excel Worksheet Functions	2	21st Jun 2005 10:40 PM