I have a quick question

I need help with a basic macro that will enable me to search a cell
that has lastname and first name seperated by a comma (lastname,
firstname). All I need to do is create two variables that will only
have either the first name or last name. For example

Variable1 = Last name
Variable2 = First name


Once I am able to do this then I should be able to add it to my code

Thank you for all of your help in advance