Dear All,
Very Good Morning ..and Have a Great Day Ahead!
I got below Function from our group . I have modified it . We can put Space
between word
for example
PrafullJadhav then output is Prafull Jadhav
AjayNareshRane then output will be Ajay Naresh Rane
MY question is Can we create Macro by
)
Next
Next
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prafull Jadhav
Sent: Tuesday, October 29, 2013 10:12 AM
To: excel-macros@googlegroups.com; excelvbacli...@googlegroups.com
Subject: $$Excel-Macros$$ UDF convert to Macro
Dear
(k)
Next
Next
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prafull Jadhav
Sent: Tuesday, October 29, 2013 10:12 AM
To: excel-macros@googlegroups.com; excelvbacli...@googlegroups.com
Subject: $$Excel-Macros$$ UDF convert to Macro
) = WorksheetFunction.Trim(k)
Next
Next
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prafull Jadhav
Sent: Tuesday, October 29, 2013 10:12 AM
To: excel-macros@googlegroups.com; excelvbacli...@googlegroups.com
Subject: $$Excel-Macros$$ UDF convert to Macro