VBA Atanh Worksheet Function – Inverse Hyperbolic Arctangent of Number

To find the hyperbolic arctangent of a number in VBA, we can use the Excel Atanh() worksheet function.

WorksheetFunction.Atanh(x)

In VBA, we can easily use trigonometric functions from the collection of VBA math functions. These VBA math functions allow us to perform trigonometry easily.

Unfortunately, there is not a function in VBA to calculate the hyperbolic arctangent of a number.

To find the hyperbolic arctangent of a number, we can use the Excel worksheet function Atanh().

Below is the VBA syntax to find the hyperbolic arctangent of a number.

WorksheetFunction.Atanh(x)

The input to the Atanh() worksheet function must be a double between -1 and 1. The return value will be a double.

Debug.Print WorksheetFunction.Atanh(0.5)
Debug.Print WorksheetFunction.Atanh(0)
Debug.Print WorksheetFunction.Atanh(-0.75)

'Output:
0.5493061443340549
0.0
-0.9729550745276566

Finding the Inverse Hyperbolic Tangent of a Number in VBA

With Excel and VBA, we can also find the inverses of the common trigonometric functions. The Atanh() worksheet function allows us to find the inverse of the hyperbolic tangent of a number.

Below, we show that if we pass a number to Tanh() worksheet function and then call the Excel Atanh() worksheet function, we get back the same number.

Debug.Print WorksheetFunction.Atanh(WorksheetFunction.Tanh(10)) 

'Output
10.0

Hopefully, this article has been beneficial for you to understand how to use the Excel worksheet function Atanh() in VBA to find the hyperbolic arctangent of a number.