I have a list of customer names in cells A87:A??
I need to sort this list, but the list might get longer when names are
added.
I have a VBA code that adds the rows, and within that same code I need
to sort this list alphabetically.
Is there a way to write this code?
I need it to only sort the rows that has the data in A87 to A[end of
the list].

something like:
y = range("A87").end(xldown).row
range("A87:A" & "y").sort xlascending

of course the above code doesn't work but it kinda shows what i want it
to do.

Any help would be greatly appreciated!


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