Thread: fast range copy (without clipboard and with formatting)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Max Belugin Max Belugin is offline
external usenet poster
  
Posts: 3
Default 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
Reply With QuoteReply With Quote