New to arrays-Resizing cell range when writing array

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.

Please Login or Register  to view this content.

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)

Uh oh. It looks the code posted has broken the 1D array write as well as the 2D (The 1D write had been working before )

Ignore Post #2. I have solved the 1D array issue. (

Please Login or Register  to view this content.

)