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

fast range copy (without clipboard and with formatting)
 

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

fast range copy (without clipboard and with formatting)
 

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

fast range copy (without clipboard and with formatting)
 

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

NickHK

"Max Belugin" wrote in message
...
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

fast range copy (without clipboard and with formatting)
 

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

fast range copy (without clipboard and with formatting)
 

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" wrote in message
...
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