This function is supposed to take a column of monthly returns and calculate the growth of $1000 over that time period.
For example: 'Results08'!B50--> =Growth1K(B:B,1)
When I calculate the result while I'm on the Results08 worksheet, the formula works great. The problem is that whenever any other cell gets recalculated on any other worksheet (ex Results07), cell 'Results08'!B50 uses the data from THAT worksheet for the calculation instead of the one it's supposed to use.
I have scoured the forums looking for an answer and I thought the code below would do the trick, but I'm still getting the same result.
The functions firstRow/lastRow return the number of the row where the first/last monthly return is for that column
Please Help, I have wasted two days of work trying to figure this out!
Bookmarks