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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top