Regression - Having trouble offsetting input/output references

Surprisingly, that is the actual output of the error message when I run my macro.
To repeat it, it says, "Regression - Having trouble offsetting input/output references"

The two button choices that appear on the bottom are "OK" or "Help." The OK button allows the macro to keep running (until it finds that it cannot find the regression output that was supposed to be created) while the Help button brings up a help window but obviously cannot find any way to be helpful.

The error takes place during the regression code:

Please Login or Register  to view this content.

This ONLY takes place when this code is part of a nested loop. It works perfectly fine on its own. I know this is a very complicated and in-depth question but I would appreciate any help.

I have heard that elsewhere, but I wasn't sure how to use LINEST. What does the output look like? Because I need the regression coefficients for each of the input variables.

I only have access to a computer running Ubuntu right now, so I cannot fulfill that request until later tonight or tomorrow.

What I really need to know is:
1. How to regress one stream of data points against 4 streams of data points
2. How do I access the output (i.e. does it create a new worksheet and I write code to copy/paste it or is it stored in memory while the code is running and I can access it via a reference to it)?
3. Is this any more or less exact than running a regression? Or is the regression function actually using this formula to output?

Attached is a sample worksheet similar to the one I'm using with the rest of my code. Previously, when using Regression, I had output into a sheet named "fund" and then i would delete it at the end of each loop. Not sure if this is similar but just thought I'd let you know.

Also, the Transpose sheet is where I use code to transpose each fund listed in FundReturn one by one. Essentially, the transpose data is the Y-set, and all 4 Indices listed in Index are the X-set.

Data in Sheet("Transpose") against data in Sheet("Index")


Fund 1 against (Index 1, Index 2, Index 3, Index 4)