thanks Rowan, but it doesn't quite work...
maybe i should explain more.
i have 2 groups of names, one right underneath the other.
so if a name is added to the first group, all the rows shift down.
i need to be able to sort just the names in the first group
alphabetically.
the 2 groups are separated by a blank line, which is why i thought
RANGE("A87").END(XLDOWN) might be useful somehow.

any help would be appreciated!


--
ayl322
------------------------------------------------------------------------
ayl322's Profile: http://www.excelforum.com/member.php...fo&userid=9846
View this thread: http://www.excelforum.com/showthread...hreadid=467641