unable to set FormulaArray property of Range class Error

Hi all. I have been lurking for a while and have learned much from the excel forum. Thanks.

More info here as well

I have attached a sample database which uses the excel functions. If you want to look at the underlying data, hold down Shift Key while opening, as I have a form loading on start.

I am getting the "unable to set FormulaArray property of Range class" error when doing the below code. When I place my breakpoint I can trace to this line:
objResultsRange.FormulaArray = objExcel.Transpose(varResults).

Sometimes this works with some ranges but does not work with others. Any help or insight would be greatly appreciated.

Please Login or Register  to view this content.