| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy conditional formatting range | Excel Worksheet Functions | |||
| Range.Copy [Destination] should not use clipboard | Excel Discussion (Misc queries) | |||
| Fast Formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting: NEED ANSWERS FAST!!! | Excel Discussion (Misc queries) | |||
| range to VBA array, and doing this fast | Excel Programming | |||
Threaded Mode
