It would seem counter intuitive to expect that copying to the clipboard
and then pasteing onto the next line would be faster so I never even
thought to try that. Thanks for the suggestion. I will give it a try.

DickN

BrianB wrote:
FWIW I have discovered that Copy/Paste methods work faster than cycling
cells - especially if formats are required.


---
Message posted from http://www.ExcelForum.com/