I have a macro that looks up values in another workbook, pastes them into the
macro's workbook, then names the range (let's say "Client_List"). The range
is named because there is another cell with data validation set as list and
referring to "=Client_List" the problem is that the size of the range to be
named "Client_List" changes, and I can't figure out a way to define the name
Client_List to refer to the new group of cells. Can anyone help? thanks

comparini3000