This module defines subroutines and functions that can be used from several different locations in the VBA project. For example:
“SheetExists” allows checking for the presence of a worksheet in an Excel workbook.
“checkItemExistsInCollection” allows checking whether a specified item exists in a collection.
“copyRangeFormat” copies several format characteristics of an excel range of cells to another range of cells. The sizes of the two ranges must match.
“setArrayAllValues” initializes all the values of an Array to the same specified value.
“clearAllModuleVariables” re-initializes the variables of several modules in the workbook.
“layersFromRange” returns an Array corresponding to a selection of Result layers. The argument of the function is an excel range (selection of cells).
These methods are called from several locations in the VBA module, but should never be used directly from an excel spreadsheet of the project.