INFO()
Syntax. INFO(type_text)
Definition. This function returns information about the operating system and Excel.
Arguments
type_text (required). A string that specifies the type of information required
Background. Table 11-5 shows the information returned by this function for different type arguments.
Table 11-5. String Arguments and Their Meaning
Argument | Return Value |
|---|---|
memused | Memory used by Excel, in bytes. |
memavail | Available memory, in bytes. |
totmem | Total memory, in bytes, including the used memory. |
recalc | Recalculation mode for the current workbook as specified in the Options dialog box: Automatic or Manual (text). |
numfile | Number of active worksheets in the open workbooks and loaded add-ins. |
system | Name of the operating system (pcdos for Windows and ... |
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
