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

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

Code:

---

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.

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