| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| 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 | |||
Linear Mode
