Switching last, first name order

Hello - I wanted to create a macro that would convert lastname, firstname to firstname lastname. I have created a button that will parse the cells that I have selected in the sheet to be converted. I want to try and do this myself, but I have a question regarding the FIND function. Apparently, this function doesn't work in VBA. You need to use the .Find function instead, but this doesn't appear to do what the FIND function does. Below is my code so far...

Please Login or Register  to view this content.

The Find function gives a compile error. I need the Find function to find a substring within a given string then return its location (index). This is my first time posting so I hope I am explaining this clearly.
Thanks,
Brian

Have a look at this link
https://www.excelforum.com/excel-pro...he-column.html