Maybe I should tell the format to transfere is in the visual way (frame,
background, font etc.

It should NOT transfere number format, date format, percent etc.

/Regards


"Gunnar Johansson" skrev i meddelandet
...
Hi,
I have merged cells , let's say in sheet1:
Reference A10 has MergeArea "A10:A14"

I want to have the same format on a similar merged area in sheet2:
"B10:B14"

Now the procedure is a copy - paste solution, but I doesn't like that.

How can I "transfere" the format?

Thanks for any help!