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.

## Leave a Reply