Thread: Translate these worksheet function to VB
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GH[_2_] GH[_2_] is offline
external usenet poster
  
Posts: 10
Default Translate these worksheet function to VB
I have the following named formulas in my workbook and I would like to
calculate results in VB and display in a message box.

LogBCoef =INDEX(LINEST(YValues,LN(XValues)),1,2)
LogCCoef =INDEX(LINEST(YValues,LN(XValues)),1)
PolyBCoef =INDEX(LINEST(YValues,XValues^{1,2}),1,3)
PolyC1Coef =INDEX(LINEST(YValues,XValues^{1,2}),1,2)
PolyC2Coef =INDEX(LINEST(YValues,XValues^{1,2}),1)
PowerBCoef =INDEX(LINEST(LN(YValues),LN(XValues),,),1)
PowerCCoef =EXP(INDEX(LINEST(LN(YValues),LN(XValues),,),1,2))
ExpBCoef =INDEX(LINEST(LN(YValues),XValues),1)
ExpCCoef =EXP(INDEX(LINEST(LN(YValues),XValues),1,2))


YValues and XYalues are named ranges.
The syntax is giving me fits. Can anyone help?

Reply With QuoteReply With Quote