|
Worksheet functions .. |
..and
their VBA equivalents |
|
|
|
|
ABS() |
Abs function |
|
ATAN() |
Atn function |
|
CHAR() |
CHR function |
|
CODE() |
ASC function |
|
COS() |
Cos function |
|
DATE() |
DATESERIAL function |
|
ERROR.TYPE() |
ERR function |
|
EXACT() |
STRCOMP function |
|
EXP() |
Exp function |
|
INDIRECT() |
No direct equivalent - use Range, |
|
|
Cells, Offset, or any other way of |
|
|
referencing cells. |
|
INFO() |
No direct equivalent - use the following: |
|
|
CURDIR function, the following |
|
|
Application properties (MEMORYTOTAL, |
|
|
MEMORYUSED, MEMORYFREE, VERSION, |
|
|
OPERATINGSYSTEM, CALCULATION, COUNT) |
|
ISBLANK() |
ISEMPTY function |
|
ISREF() |
TYPENAME function |
|
LEN() |
LEN function |
|
LOWER() |
LCASE function |
|
N() |
No equivalent (none needed) |
|
NA() |
No equivalent - use |
|
|
ActiveCell.Value = "#N/A" |
|
RAND() |
RND function |
|
RANDOMIZE() |
Randomize function |
|
SIN() |
Sin function |
|
SIGN() |
Sgn function |
|
SQR() |
Sqr function |
|
SQRT() |
Sqr function |
|
T() |
No equivalent (none needed) |
|
TAN() |
Tan function |
|
TODAY() |
DATE function |
|
TRUNC() |
FIX function |
|
TYPE() |
TYPENAME function |
|
UPPER() |
UCASE function |
|
VALUE() |
VAL function |