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

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

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

Regards,
Peter T

"Guitar Billy"
wrote in message
news:Guitar.Billy.2cxr9q_1156240506.1618@excelforu m-nospam.com...

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

Just the job! Works a treat.
Thank you.


--
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