I am trying to write a project level function that will automatically write a 1D or 2D array into another (closed) workbook. *
See code below. It is working fine for 1D arrays but it is not working on 2D arrays (line 120). I'm sure it is something completely obvious but I am new to arrays and need help.
P.S. I recommend using ScreenUpdating = False/True before and after calling this function.
* Provided you supply the arguments of (array and the closed workbooks folder path, file name, sheet name and which cell to start from) it should auto determine whether you want to write a 1D or 2D array, open the closed workbook, write the data to the sheet/starting cell required and then closed the workbook. The function will then return True or False depending on whether it was successful or not. (For error checking purposes)