I am reading a large number of rows by a large number of columns by column from a spreadsheet. I've found the easiest way is to use NextRow(db) then reset the rows to the top. I just haven't found an easy method for resetting the row counter to the top. Currently I re-declare the db variable like: <db = OpenRecordSet("Standard Main")>, but since I need to change the sheet name so that I can reuse the script, I need to be able to reset based on a passed varible, if possible. I've tried a loop using "PrevRow", but that gets slow and messy.

Any ideas on resetting the row counter?