Grab the Free VBA Quick Reference Guide
https://www.chrisjterrell.com/excel-vba-quick-reference-guide/
In this Macro Monday challenge create a function that removes characters \ / * [ ] : ?
Code
Function SheetString(Name)
'Name = Application.WorksheetFunction.Substitute(Name, "\", "")
'Name = Replace(Name, "\", "")
s = Split("\,/,*,[,],:,?,90", ",")
For r = 0 To UBound(s)
Name = Replace(Name, s(r), "")
Next
SheetString = Name
End Function
Download
0 formats
No download links available.
Macro Monday Function to Remove Characters with 3 Solutions | NatokHD