fast range copy (without clipboard and with formatting)

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

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

--
HTH

Bob Phillips

"Max Belugin" <[email protected]> wrote in message
news:[email protected]...
> 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

20.06.05 в 13:20 Bob Phillips в своём письме писал(а):

> Have you tried the format painter, the paintbrush icon on the formatting
> toolbar?
Thank you.
Okay, it copies formatting, but i want also copy values, row heights, etc
-- so i want the exact copy of source range.

--
http://belugin.info

Max,
Doesn't a normal Copy-Paste achieve this ?

NickHK

"Max Belugin" <[email protected]> wrote in message
news:[email protected]...
> 20.06.05 в 13:20 Bob Phillips в своём письме писал(а):
>
> > Have you tried the format painter, the paintbrush icon on the formatting
> > toolbar?
> Thank you.
> Okay, it copies formatting, but i want also copy values, row heights, etc
> -- so i want the exact copy of source range.
>
> --
> http://belugin.info

20.06.05 в 14:26 NickHK в своём письме писал(а):

> Max,
> Doesn't a normal Copy-Paste achieve this ?

It does achieve this, but it modifies clipboard -- see the origin of thread

--
http://belugin.info

Sorry, I thought you just wanted formatting.

Only way I can think of is to use to VBA to pick up the values, formats etc,
and apply same to target, but there are so many properties this would be
awful.

--
HTH

Bob Phillips

"Max Belugin" <[email protected]> wrote in message
news:[email protected]...
> 20.06.05 в 13:20 Bob Phillips в своём письме писал(а):
>
> > Have you tried the format painter, the paintbrush icon on the formatting
> > toolbar?
> Thank you.
> Okay, it copies formatting, but i want also copy values, row heights, etc
> -- so i want the exact copy of source range.
>
> --
> http://belugin.info