Good day all,

Do any of you happen to know if there's an easy way to obtain the total number of rows used in multiple spredsheets without opening all of them?

Each spreadsheet contains a single sheet with data, all of which have the same sheet name. There are approximately 575, some of which have as few as 8 lines, others wth as many as 100,000. This isn't urgent - it's for a status report and I can always run something to open each file, do a countif, then save the response and close the file. Just thought there may be a faster way to do it.

Again, this isn't terribly important - but if anybody has an easy ideas, I'd apprecaite hearing about it.

Thanks
JP