xpna.INFO FUNCTION
Usage
The INFO function is a helper function in xpna that gives a result based on the infoType specified.
The available types are:
| Type | Arguments | Description |
|---|---|---|
| address | arg1: A cell reference | Returns the full sheet reference to the caller. Note: This is to work around the shortcomings of the Excel CELL("address", <ref>) formula which only ever returns the cell address even if it is called with a sheet reference |
Syntax
| Argument | Description |
|---|---|
| infoType | One of the valid infoTypes. |
| [arg1..argN] | The applicable argument values for the infoType selected |
Common Problems
- The function will return an error if you do not provide the correct arguments for the infoType requested.