I have a macro that returns the user's name in this format:"Doe, John". What I want is to be formatted like:"John Doe".
Here is the macro I am working with.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim ws As Worksheet
Set ws = ActiveSheet