Hi snb,

well this code does not work for me, I run the code, but the message box shows up with no value. And more importantly I don't need to show the number in the message box,
I need to get the results from all the original 50k excel files from the cell N2 (for explanation see above) into the new excel file, thus in the new excel file, there will be 50k rows with 50k values(ideally with the name of the original file in the next column)