emreko
06-27-2014, 05:42 PM
Hi,
My question is about the macro posted in this link
Consolidate multiple workbooks from a folder into one master file VBA (http://www.excelfox.com/forum/f13/consolidate-multiple-workbooks-folder-into-one-master-file-vba-569)
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.
My question is about the macro posted in this link
Consolidate multiple workbooks from a folder into one master file VBA (http://www.excelfox.com/forum/f13/consolidate-multiple-workbooks-folder-into-one-master-file-vba-569)
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.