Match Formatting
 

My VBA code creates multiple sheets and fills them with data. Each
time a new sheet is created it has default formatting. I have a sheet
that's formatted exactly as I want it, and I'd like for these newly
created sheets to take on that formatting.

Is there any way I can code it so that the formatting of the new
sheets is the same as the formatting of that existing sheet?

Match Formatting
 

On Aug 17, 10:05 am, Chris wrote:
My VBA code creates multiple sheets and fills them with data. Each
time a new sheet is created it has default formatting. I have a sheet
that's formatted exactly as I want it, and I'd like for these newly
created sheets to take on that formatting.

Is there any way I can code it so that the formatting of the new
sheets is the same as the formatting of that existing sheet?

When I say formatting, the things in particular that I'm looking are
data type (number, date, percentage, etc.) and column width. I'd
really like for new sheets to retain those properties.

Match Formatting
 

Sorry! Never mind. Instead of creating a new sheet, I just created a
template and copied that sheet. Easy enough.

Thanks anyway.