Thread: How to embed ^{1,2,3} in TREND Function in VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tetsuya Oguma Tetsuya Oguma is offline
external usenet poster
  
Posts: 19
Default 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
Reply With QuoteReply With Quote