Steve Jukes
Board Regular
- Joined
- Apr 15, 2002
- Messages
- 83
Please help.
I have a list of companies and some have a * at the end of them. When I run the code below it deletes the whole name, even if the matchcase is set to false.
Any ideas???
Thankyou in advance for your help!!!!
Worksheets(1).Columns("b").Replace _
What:="*", Replacement:="", _
SearchOrder:=xlByColumns, MatchCase:=True
I have a list of companies and some have a * at the end of them. When I run the code below it deletes the whole name, even if the matchcase is set to false.
Any ideas???
Thankyou in advance for your help!!!!
Worksheets(1).Columns("b").Replace _
What:="*", Replacement:="", _
SearchOrder:=xlByColumns, MatchCase:=True