I have a workbook where I need to name a range of cells. Lets call it “Data”. Each cell within the range needs a unique descriptive name so it can be easily referenced from other worksheets. I have the naming worked out and have populated a range 10 columns over with values equal to what i want the cells in my range to be named. We can call that range “Names”. How can I use the values from Names to change the cell names of the cells in Data?
I have googled this and found bits of code related but I am not a VBA expert and haven’t been able to get anything to work