I have a large number of excel files I need to open and run a macro to count columns and count non-blank and blank values on a row. The first 8 columns are the same and then after ~ the columns per file various. It could be 1 column to 45 columns. Also a file could have only 1 record or it could have over 300 records. I am trying to figure out a way to open all of the files at once apply the macros to remove a few columns and add 3 columns to hold the "total count", "blanks", and "completed" values, along with having the output from each file combined into one larger file. Any help would be greatly appreciated.