How to embed ^{1,2,3} in TREND Function in VBA
 

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

How to embed ^{1,2,3} in TREND Function in VBA
 

Evaluate("TREND(A1:A10,B1:B10^{1,2,3},C1^{1,2,3},T RUE)")

--
Regards,
Tom Ogilvy



"Tetsuya Oguma" wrote:

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