Using Application.WorksheetFunction.Ln(...) in VBA

  • Thread starter Thread starter doco
  • Start date Start date
D

doco

Hello;

I have searched the help files, several programming in excel books and this
forum to try to discover how to convert a Range object into it's constituent
double values in order to use Ln(...) in module.. eg

dLog = Application.WorksheetFunction.Ln(oXValues) where "oXValues" is a
range of values from a worksheet.

Obviously a range object is not a Double. I am trying to produce the Slope
and Intercept coefficients for a graph. IE for Logrythmic regression one
would use Slope(knownYValues, LN(knownXValues)) & Intercept(knownYValues,
LN(knowXValues)). This works great when used in a spreadsheet. However,
Type Mismatch is returned when using "dLog =
Application.WorksheetFunction.Ln(oXValues)" in a module.

How would the Slope and Intercept values be discovered in VBA?

TIA
doco
 
Back
Top