If you're building that second sheet, you could just copy the worksheet (not the
cells).

Edit|move or copy sheet

Then start from there.

Gunnar Johansson wrote:

Hi,

Is there a way of always be sure that the cell format - all formats like
.font, .border, .height, autoformat etc always can be cloned between two
sheets? How close gat I get if not exactly "yes"? How?

I would be nice if there had been a ...range.cells.format just as there is
range.cells.value and .formula

Regards

--

Dave Peterson