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