Workbook Name Definitions for Setting Storage

Another way to store settings is by using workbook or worksheet name definitions. I feel this is a little bit sneaky, but once in a while, it's fun to be sneaky. Most Excel users aren't aware that you can set up constants in a workbook using the name functionality. For example, you could create a name called SalesTaxRate and have it refer to the value .06 rather than a cell or range in the workbook, as shown in Figure 13.2. Figure 13.3 shows an example of how you use the name from a worksheet.

0 0

Post a comment