Pass a variable to another subroutine and get back the result

Hi,

In my application, I read the contents of a cell which contains the full name. I need to split the full name into the three components - Surname, First Name and the Middle Name.

In my code I read the full name and pass this to another subroutine to split the full name into Surname, First Name and Middle Name. This portion seems to work fine. Where I am having a problem is getting back the Surname, First Name and Middle Name after the split. This comes back empty. The code is posted below. Would be really grateful if some one can point out the mistake I have made and give me correct code.

Please Login or Register  to view this content.

xlLastRow is a function written to get the first blank row in the worksheet. There is no problem with this routine.

Thanks a ton in advance

Anand