That's a copy & paste method (PasteSpecial)...
It has to be in VBA.
/Regards
"Jim May" skrev i meddelandet
news:inxEc.20765$WI2.14551@lakeread05...
How bout using the Format-Painter (Icon) method?
"Gunnar Johansson" wrote in message
...
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!
|