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.
Bookmarks