[RESOLVED] What can I use to make the Replace command not case sensitive?

Need the word "LoT" within in a string, not to be case sensitive when I replace it with “Lot “

Code:

---

ActiveCell.Value = Replace(Replace(ActiveCell.Value, "LoT", "Lot "), "$", "")

---

The Keyword UPPER works when using substitute in a formula but apparently not with Replace in VBA

Thanks

Hmmm, .. solved...
tinkered around with it a little and soon realized that Ucase and spelling the word in uppercase, was all I needed :bigyello:

Code:

---

ActiveCell.Value = Replace(Replace(UCase(ActiveCell.Value), "LOT", "Lot "), "$", "")

---

You are learning fast ;)

Sid