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