Well, named ranges are nothing but some excel ranges that a tagged with some meaningful name For example, if you have a cell say B1, contains the everyday target, you can name that cell as specifically "Target" Now you can use "Target" to refer at A1 instead of writing B1What is Name Range in Excel?Excel VBA Create Named Range StepbyStep Guide and 4 Examples to Define Named Ranges with Macros By JA Gomez In this VBA Tutorial, you learn how to create named ranges (for different ranges and with different scopes) with macros This VBA Tutorial is accompanied by Excel workbooks containing the macros I use in the examples below You can get immediate free
Excel Named Range Customguide