You can use a for/each loop adding the number to the last one using the idea
I gave you.

BTW. It is NOT useful for you to jump on those trying to offer assistance.
Sometimes we like a little humor around here.

--
Don Guillett
SalesAid Software

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