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

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" <comparini3000@discussions.microsoft.com> wrote in message
news:7B7ACAB1-F350-4C45-A99C-EAE2FB3D6109@microsoft.com...
>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