Welcome to Bowdoin | Bowdoin College

' When one wants to use a nested Excel function in VBA, ' each Excel function must be preceeded by Application. ' Below we combine Index and Linest to generate the ' equivalent of the Excel function Index (LinEst(y-range, ' x-range,stats,const),row-index,column-index) to fit a ' straight line to seven adjacent data points, and to ................
................