Named Ranges

[Guitar Billy]

I am trying to use VB to enter TREND functions into my worksheet. This
works OK if I use code similar to the following,

ActiveSheet.Range(Cells(7, 9), Cells(7, 13)).Select
Selection.FormulaArray = _

"=TREND(R[-4]C[-7]:R[-4]C[-1],R[-6]C[-7]:R[-6]C[-1],R[-6]C:R[-6]C[4])"

or
Range("L2626").Select
Selection.FormulaArray =
"=TREND(TestRange1,Testrange2,TestRange3)"


but I want to be able to change the ranges as required.
Q1.. Can I use variables in these lines or
Q2.. Can I create Named Ranges using variables.

Thanks in anticipation

 

[Peter T]

sFormula = "=TREND(" & sAddr1 & "," & sAddr2 & "," & sAddr3 & ")"

ActiveSheet.Range(Cells(7, 9), Cells(7, 13)).FormulaArray = sFormula

Regards,
Peter T

"Guitar Billy" <[email protected]>
wrote in message
news:[email protected]...

 

[Guitar Billy]

Just the job! Works a treat.
Thank you.