I'm looking for a macro that looks through a folder and for each excel workbook in the folder lists the workbook, worksheets and the bottom used cell for each sheet.
I can probably put something together but I'd think there would be a macro already out there somewhere which does such a thing. I'm struggling with what to search for though and generally getting solutions with file sizes. Any suggestions for such a macro that you're aware of.
Cheers
I'm looking for a macro that looks through a folder and for each excel workbook in the folder lists the workbook, worksheets and the bottom used cell for each sheet.
I can probably put something together but I'd think there would be a macro already out there somewhere which does such a thing. I'm struggling with what to search for though and generally getting solutions with file sizes. Any suggestions for such a macro that you're aware of.
Cheers