I want to loop through a range of cells and test for a condition. When the
first cell that meets the condition is found, add a defined name (i.e.
MyRange). As I continue looping through the cells, each cell that meets the
condition has to be added to that defined name.

Is there an easier way to do this rather than manipulate the RefersTo string?

Frank