define the name
in the refers to box
=offset($C$2,0,0,counta(c:c)-1,9)
then it will be self-adjusting. Change c:c to the longest in the range

--
Don Guillett
SalesAid Software

"Man Utd" wrote in message
...
I have name a cell range say from C2:K5 as NameLookup.
Now I added some rows to it so the range should be C2:K10 and want to name
the same name.
How do I do that?