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

[SQLADOman]

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

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