Function in VBA and putting it into excel

Try this...

Please Login or Register  to view this content.

Please use CODE tags around your code

The only problem that I see is the wrong number of arguments of the Log function.
Try this

Please Login or Register  to view this content.

Here is extract from Help for VBA.Log function which you are using. Note that it's natural log anyway - no need to specify the log base

Log Function

Returns a Double specifying the natural logarithm of a number.

Syntax

Log(number)

The required number argument is a Double or any valid numeric expression greater than zero.

Remarks

The natural logarithm is the logarithm to the base e. The constant e is approximately 2.718282.

You can calculate base-n logarithms for any number x by dividing the natural logarithm of x by the natural logarithm of n as follows:

Logn(x) = Log(x) / Log(n)

The following example illustrates a custom Function that calculates base-10 logarithms:

Please Login or Register  to view this content.

If you want to specify the log base use the example from the help or use WorksheetFunctions.Log


@Sixthsense: Application doesn't have Log method

Originally Posted by buran

@Sixthsense: Application doesn't have Log method

Please check it and let me know if it fails

We can substitute Worksheetfunction with Application

Originally Posted by :) Sixthsense :)

Please check it and let me know if it fails

We can substitute Worksheetfunction with Application

Frankly, for so many years I didn't knew that :-)

Originally Posted by buran

Frankly, for so many years I didn't knew that :-)

It 's better to avoid WorksheetFunction and use Application. The below is a simple example I created for your (since you are interested) which will explains the advantage of using Application.

Run each code and see how application/worksheetfunction handles the error if the match is not found

Please Login or Register  to view this content.

Thanks, Sixthsense :-)