How to make this code search subfolders??

Hey guys,

Can't remember where I got this code from, but I think it was on the excel references site, wherever that is.

Anyway, what it does is, it searches a folder for all excel files, then copies a defined range of cells from those files using a loop function for every file in that folder, then pastes those values into a new workbook. This works great, but what I would like it to do is be able to search subfolders as well, rather than me having to define every folder within that directory. Perhaps someone knows a way to code another loop function to search for folders within the folder? Thanks for taking a look,

Please Login or Register  to view this content.