I appreciate your help. Let me try to describe it better.

if range("a1")=100 then range("a2:a100").name "Bill"

Then I want the next name to be assigned to the following rows
if range("b1")=125 then range"a101:a226".name"John"

How can I do this so that the new name starts 1 cell after the last name
ends. I have over forty names to do this for. I've been trying for hours to
figure it out.

"Don Guillett" wrote:

yes, but you need to give us more detail.

if range("a1")=2 then
range("a2:a200").name="Bill"

--
Don Guillett
SalesAid Software

"Jday" wrote in message
...
I have a worksheet that contains up to 4000 rows of data. I want to
assign a
unique name a variable number of rows based on the outcome of a formula in
another sheet. Let me try to make it clear: I have the 4000 rows of
information. I have 50 people that I want to assign the information in
these
rows to. Based on the varible the frist person has the first 483 rows.
The
second has the next 235 and so on until they are all assigned. Is this
possible to do in Excel?