excelCPU icon indicating copy to clipboard operation
excelCPU copied to clipboard

Setting Named ranges to improve readability of formulae

Open NPueyo opened this issue 1 year ago • 0 comments

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): imagen

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.

NPueyo avatar Feb 18 '24 18:02 NPueyo