yes, but you need to give us more detail.
if range("a1")=2 then
range("a2:a200").name="Bill"
--
Don Guillett
SalesAid Software
[email protected]
"Jday" <[email protected]> wrote in message
news:[email protected]...
> 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?
Bookmarks