Use Copy range of cells and then Paste Format.

Jan

"Gunnar Johansson" wrote in message
...
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