Forum Discussion
Solved
Need help to replace certain string like "/" in the cell to underscore during save as pdf
Hi everyone, I'm not very good at excel VBA and hoping you guys can help me to replace certain characters like "/" to "_" if the character exists in the cell that I wanted to print, like in the cod...
Change
strName = wsA.Range("f10").Value _ & " - " & wsA.Range("d3").Valueto
strName = Replace(wsA.Range("f10").Value _ & " - " & wsA.Range("d3").Value, "/", "_")
Change
strName = wsA.Range("f10").Value _
& " - " & wsA.Range("d3").Valueto
strName = Replace(wsA.Range("f10").Value _
& " - " & wsA.Range("d3").Value, "/", "_")Thank you very much HansVogelaar , it works like charm. This really helps me and my fellow friend. Thanks again for your help.
