excelCPU
excelCPU copied to clipboard
Setting Named ranges to improve readability of formulae
The main objective of this PR is to set a name range for each cell used in the project in order to improve the readability of the formulae as can be seen in the screenshot (Formulae in spanish):
In order to achieve this I have create 3 VBA Macros to Import/Export/Update Named Ranges that I have stores in my own repo Manage_NamedRangesFromCSV.bas.
The CSV created with all Named Ranges of the CPU.xlsx wb is stored in NamedRanges.csv to freely view and edit the names before importing them.