Thanks very much for the help!
TestSheet.Range(Cells(i, 1).Address, Cells(i, 6).Address
did the trick
I've got two Excel VBA ebooks here, and neither mention the need for 'Address'. Not worth the paper they're not written on!
I should add that there's an error in the next line. It should read:
OutputSheet.Range(Cells(i, 1).Address, Cells(i, 6)).PasteSpecial
Paste won't work - but at least the error message is intelligible enough that you can go to the object browser and look up something that will...
Bookmarks