INFO
Syntax:
INFO ( category )
Description: Retrieves the operating environment value that corresponds to category.
Arguments:
Name |
Type |
Description |
---|---|---|
category |
text |
The string designated by category is not case-sensitive. The valid strings are shown in the table below. |
category |
Meaning |
Result Type |
---|---|---|
"directory" |
Path of the current directory or folder. |
text |
"memavail" |
Amount of memory available, in bytes. |
number |
"memused" |
Amount of memory being used for data. |
number |
"numfile" |
Number of active worksheets in the open workbooks. |
number |
"origin" |
The absolute cell reference of the top and leftmost cell visible in the window, based on the current scrolling position, prefixed with
"$A:" . example: : Using cell D9 as an example, the return value would be $A:$D$9.
|
text |
"osversion" |
Current operating system version. |
text |
"recalc" |
Current recalculation mode: |
text |
"release" |
Version of the implementation. |
text |
"system" |
Name of the operating environment. |
text |
"totmem" |
Total memory available, including memory already in use, in bytes. |
number |
Return Type and Value: text – The operating environment value that corresponds to category.
However, if category is not one of the values defined above, #VALUE!
is returned.
INFO("memused") might result in 1474464INFO("numfile") might result in 5INFO("origin") might result in $A:$C$536
INFO("osversion") might result in Windows (32-bit) NT 5.01INFO("recalc") might result in Automatic
INFO("release") might result in 11.0
INFO("system")
might result in pcdos
INFO("totmem")
might result in 2523040
]