"Clone" cell formats between sheets?

[Gunnar Johansson]

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

 

[Jan Nademlejnsky]

Use Copy range of cells and then Paste Format.

Jan

 

[Gunnar Johansson]

Oh, except pastspecial method. Sorry, I forgot that

 

[Gunnar Johansson]

Any other than that?

/regards

 

[Dave Peterson]

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.