Комментарии:
why are you saying
name=ename
name=worksheetfunction.proper(name)
cells(orow,"d").value=len(name)
why didn't you just say
cells(orow,"d").value=len(ename)
...
cells(orow,"m").value=worksheetfunction.proper(ename) & " works at the " & city & " office"
Pls share filw
Ответить