using variables in a range of formular

[lin-jin]

someone know how to include a variable in a formular using macro?

eg.
Dim a As Double
range("a1").select
ActiveCell.FormulaR1C1 = "=Linest(range(cells(2,4),cells(a,4)),range(cells(2,5),cells(a,5)),true,true)"

this is not working and displayed the whole formular as a string.

any hlep will be very very appreciated.

[Bryan Hessey]

someone know how to include a variable in a formular using macro?

eg.
Dim a As Double
range("a1").select
ActiveCell.FormulaR1C1 = "=Linest(range(cells(2,4),cells(a,4)),range(cells(2,5),cells(a,5)),true,true)"

this is not working and displayed the whole formular as a string.

any hlep will be very very appreciated.

Hi,

the formula you are using appears incorrect, the closest I could come to a translation was

ActiveCell.Formula = "=LINEST(A4:B4,A5:B5,TRUE,TRUE)"

if you want this to be 'row' variable , then

dim iRow as long
iRow = 4
ActiveCell.Formula = "=LINEST(A" & iRow & ":B" & iRow & ",A" & iRow +1 & ":B" & iRow +1 & ",TRUE,TRUE)"

hth
---