G
Guest
Hi all,
I can write the TREND function formula below in Excel cell;
=TREND(A1:A10,B1:B10^{1,2,3},C1^{1,2,3},TRUE)
How can I do this in Application.Worksheetfunction.Trend()?
I am getting an error after my try below...
Application.WorksheetFunction.Trend(range(A1:A10), range(B1:B10)^{1,2,3},
range("C4")^{1,2,3},TRUE)
Thanks in advance,
Tetsuya Oguma
I can write the TREND function formula below in Excel cell;
=TREND(A1:A10,B1:B10^{1,2,3},C1^{1,2,3},TRUE)
How can I do this in Application.Worksheetfunction.Trend()?
I am getting an error after my try below...
Application.WorksheetFunction.Trend(range(A1:A10), range(B1:B10)^{1,2,3},
range("C4")^{1,2,3},TRUE)
Thanks in advance,
Tetsuya Oguma