Indeed, I've written a second loop. One loop to open the files ineach sheet, another loop to format each sheet.