Hi,
Need some help on this.
Unable get the "Linest" formula to work.
Not sure if the arang in the formula is allowed.
Sub Macro3()
'
' Macro3 Macro
'
'
'
Dim arang As Integer
arang = 2
Do While Cells(arang, 6).Value <> ""
arang = arang + 1
Loop
Range("L2:S30").Select
Selection.FormulaArray = "=Linest(R2C6:RarangC6,RC[-11]:R[28]C[-7],1,1)"
'ActiveWindow.SmallScroll Down:=-10
End Sub
Bookmarks