Thank you. I have used the method of looping through the names in the
workbook before, but I wanted to avoid it because I have several
hundred named cells and the main objective of my code is to determine
the name of the cell so I can write a value to that cell from a
separate sheet. For example
Hi,
I have an excel workbook that is working in a similar manner to a
database in that I write the values for named ranges to a separate
sheet that contains all of the variables in columns. In order to
accomplish this I have a macro that searches a sheet for all of the
named cells on that sheet
