using match to insert a name alhpabetically

[Willardio]

Hello all,

I am trying to adapt the code at:

http://www.mrexcel.com/forum/excel-q...lications.html

I want to select the vertical range for the unit name in column A, then insert the new name from the userform (invoked by the "Add Name" command button) alphabetically in the list for that unit at column I using worksheetfunction.match.

here's my sample:

Hsample.xls

This has to be done using Excel 2003. Any suggestions can only help.

Thanks,

Willardio

[AlphaFrog]

Please Login or Register  to view this content.

[Willardio]

"Look, up in cyberspace! It's a bird! It's a plane! It's a frog. IT'S...ALPHAFROG!!!"

AlphaFrog, you're my hero!

Willardio