i am trying to do vba code to get PROPER capitalisation of a name.
customer = range("d2").value ---> (joe blow)
Range("B11").Value = "=PROPER(" & "" & customer & "" & ")"
i can get customer. but i cant get the code in b11 to put the correct formula.. I need it to read
b11: =PROPER("joe blow") ---->=Joe Blow
help is urgently needed please
customer = range("d2").value ---> (joe blow)
Range("B11").Value = "=PROPER(" & "" & customer & "" & ")"
i can get customer. but i cant get the code in b11 to put the correct formula.. I need it to read
b11: =PROPER("joe blow") ---->=Joe Blow
help is urgently needed please