VII.4.3.7 “UTIL” VBA module

This module defines subroutines and functions that can be used from several different locations in the VBA project. For example:

• “SheetExists” allows to check the presence of a worksheet in an excel workbook.
• “checkItemExistsInCollection” allows to verify if 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.