Hello, I have multiple excel spreadsheets that have varying numbers of rows. Is there a way to find the last row of a spreadsheet(that holds data)? I need to exit a loop when I get to the last row, not when I get to the end of the file. Right now I have to input special text in the last row and check for it in my loop. I was think worksheets(1).rows().count, but that gives the max rows, not how many are actually holding data or the last row that holds valid data. Any help is appreciated, thanks.