Have you tried the format painter, the paintbrush icon on the formatting
toolbar?

--
HTH

Bob Phillips

"Max Belugin" wrote in message
...
Is it possible to copy ranges with formatting without using clipboard

Range1.Copy Range2 uses clipboard, so int large loop it does not allow
comfortable work in other applications

AFAIK, it extremely slows down copying while running under terminal server
(because of sopying clipboard contents via network).

I have googled alot for the right solution, but the only tip i've found
was using values copy (TargetRange.Value=SourceRange.Value) -- it does not
fit to my needs because i want copy format too.

Thank you for your answers!

--
http://belugin.info