I doubt there's much speed difference (more perception than reality) as my code and Dave's is nearly identical.
However, this line of Dave's code:
is more specific to users of versions prior to Excel 2007+ because those versions are limited to 65, 536 rows.
Seeing as you are using Excel 2010 and have *MANY* more rows, there is risk of truncating the data if the total number of copied cells in your worksheet exceeds 65,536. Dave's code will not see available rows beyond that number.
I am using the more generic "Cells" method, which is compatible with any version.
Bookmarks