bizpioneer
New Member
- Joined
- Apr 28, 2014
- Messages
- 31
So I am trying find replace macro to replace any % "single byte" to % double byte but looks like macro doesnt recogize double bytes
So here is my macro
Range("A1").Select
columns("K:N").Select
Selection.Replace What:="%", Replacement:="%", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("H1").Select
Range("A1").Select
When I run it just replace the single byte sign with a single byte sign, anyway I can fix that so it replaces it with the double byte?
Thanks,
So here is my macro
Range("A1").Select
columns("K:N").Select
Selection.Replace What:="%", Replacement:="%", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("H1").Select
Range("A1").Select
When I run it just replace the single byte sign with a single byte sign, anyway I can fix that so it replaces it with the double byte?
Thanks,