Consolidate Multiple Workbooks With Different and Same Column Headers To Master File

[emreko]

Hi,

My question is about the macro posted in this link

Consolidate multiple workbooks from a folder into one master file VBA

The code worked perfectly in my case with small number of files (20-25). In bigger groups the code stops after processing a number of files and debugger highlights the line

 k(n, j) = d(r, c)

.

I suspect that there is a limit for number of columns in the master file. The maximum number of columns i was able to consolidate in my master file was 58.

Thanks in advance.

[Admin]

Stick with your thread at Ozgrid. Also read message to cross posters in my signature.