Eloise T
Active Member
I have a VBA macro using .Replace that looks for variations of "Canceled" and replaces the variation with (you guessed it) "Canceled"
It converts: cancelled, CANCELLED, canceled, BUT not CANCELED... it leaves it as CANCELED.
How do you get .Replace to check for correctly spelled UPPER CASE CANCELED and change it to Canceled?
I tried changing xlWhole to xlPart with no effect.
Thanks in advance for your assistance.
.Replace "cancelled", "Canceled", xlWhole
.Replace "CANCELED", "Canceled", xlWhole
It converts: cancelled, CANCELLED, canceled, BUT not CANCELED... it leaves it as CANCELED.
How do you get .Replace to check for correctly spelled UPPER CASE CANCELED and change it to Canceled?
I tried changing xlWhole to xlPart with no effect.
Thanks in advance for your assistance.
.Replace "cancelled", "Canceled", xlWhole
.Replace "CANCELED", "Canceled", xlWhole