I have a spreadsheet that I need to load data from another spreadsheet. The spreadsheet I want the data loaded into is a template and the other spreadsheet can have one to N rows. How can I progammaticly find out how many rows I have in my second spreadsheet and then use that in my for..next loop

Thank

Dwaine Horto
York International