"Clone" cell formats between sheets?
 

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

"Clone" cell formats between sheets?
 

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

"Clone" cell formats between sheets?
 

Oh, except pastspecial method. Sorry, I forgot that
"Jan Nademlejnsky" skrev i meddelandet
...
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

Forgot to mention : EXCEPT Pastespecial method
 

Any other than that?

/regards



"Gunnar Johansson" skrev i meddelandet
...
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

"Clone" cell formats between sheets?
 

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