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