Dynamic Name Labels
 

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

Dynamic Name Labels
 

Something like this perhaps:
Range("A2",Range("A" & Rows.Count).End(xlUp)).Name = "Client_List"
Change the cell references as needed.
This code names the range from A2 to the last entry in Column A
"Client_List".
HTH Otto

"comparini3000" wrote in message
...
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