Just something to test for...I found that the copy/paste techniques that use
the clipboard can generate a lot of page faults which will slow down Excel.
To determine if you are experiencing the page fault problem:

1. Open Task Manager
2. If you don't see the Page Faults column, then from the File menu select
View->Select Columns... and check the box next to Page Faults

As Excel is loading the data, watch the Page Faults value associated with
that instance of Excel. If page faults are the problem you will see the page
faults growing and the program slowing.

Just something else to look at when considering performance issues in Excel.
I'm sure that Tom's solution will fix your problem because it handles the
copy as one block.

Kim

--
digipede - Many legs make light work.
Grid computing for the real world.
http://www.digipede.net
http://krgreenlee.blogspot.net