Used to raise a number to the power of an exponent.

## Syntax

*result*=*number***^***exponent*

The **^** operator syntax has these parts:

Part | Description |
---|---|

result |
Required; any numeric variable. |

number |
Required; any numeric expression. |

exponent |
Required; any numeric expression. |

## Remarks

A *number* can be negative only if *exponent* is an integer value. When more than one exponentiation is performed in a single expression, the **^** operator is evaluated as it is encountered from left to right.

Usually, the data type of *result* is a Double or a Variant containing a **Double**. However, if either *number* or *exponent* is a Null expression, *result* is **Null**.

## Example

This example uses the **^** operator to raise a number to the power of an exponent.

```
Dim MyValue
MyValue = 2 ^ 2 ' Returns 4.
MyValue = 3 ^ 3 ^ 3 ' Returns 19683.
MyValue = (-5) ^ 3 ' Returns -125.
```

For 64-bit users: Because the caret operator is used to create Long Long data types in a 64-bit environment, the VBA IDE may not interpret this operator correctly. To ensure proper interpretation, add a space character immediately before the caret as shown.

```
x=y^2 ' Will generate "expected )" from VBA IDE.
x=y ^2 ' Will be interpreted as x equals y squared.
```