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("L26:P26").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]...
>
> 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("L26:P26").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
>
>
> --
> Guitar Billy
> ------------------------------------------------------------------------
> Guitar Billy's Profile:
http://www.excelforum.com/member.php...o&userid=37859
> View this thread: http://www.excelforum.com/showthread...hreadid=574104
>

[Guitar Billy]

Just the job! Works a treat.
Thank you.