Skip to main content

Module formulas

Module formulas 

Source
Expand description

Formulas tab: AutoSum, Insert Function, names, auditing, calculation.

Functions§

function_list
number_stored_as_text
The number a cell’s text stands for when Excel’s background check flags it as a number stored as text: a constant (not a formula’s result) that would be a number if typed.
pasteable_names
The names Paste Names lists, as (name, refers-to text with =): the workbook’s names and the active sheet’s own, without hidden names, in alphabetical order. A sheet’s name hides the workbook name it shares.
specs