Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selection.PasteSpecial with Office 2003
Hi Newsgroup
I have the following VBA-Code in an Excel-Sheet to copy from the clipboard: Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=True That works good, but after the change to Office 2003 i have a performance problem with the Selection.PasteSpecial. Have anyone an idea to make it fast? Thanks and greetings Andy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selection.PasteSpecial with Office 2003
In order to copy and paste a range, it need not be selected.
This should improve performance. Sub test() Range("a1").Copy Range("b1").PasteSpecial xlValues End Sub "Andreas Szabo" wrote: Hi Newsgroup I have the following VBA-Code in an Excel-Sheet to copy from the clipboard: Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=True That works good, but after the change to Office 2003 i have a performance problem with the Selection.PasteSpecial. Have anyone an idea to make it fast? Thanks and greetings Andy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selection.PasteSpecial with Office 2003
I don't see anything in your snippet of code that would cause a slowdown.
Maybe you added a worksheet event that fires when you make a change and the paste special causes that to fire... application.enableevents = false 'your code to paste application.enableevents = true Andreas Szabo wrote: Hi Newsgroup I have the following VBA-Code in an Excel-Sheet to copy from the clipboard: Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=True That works good, but after the change to Office 2003 i have a performance problem with the Selection.PasteSpecial. Have anyone an idea to make it fast? Thanks and greetings Andy -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does Selection.PasteSpecial toggle Application.ScreenUpdating | Excel Worksheet Functions | |||
Excel 2003 vs 2000: PasteSpecial | Excel Programming | |||
Problem sharing spreadsheet between Office10 (Office XP) and Office 11 (Office 2003) | Excel Programming | |||
selection.pastespecial problem | Excel Programming |