What is the best way to code VBA for the associated SUBSTITUTE command in
cell formulas...

I want to delete a character from my string. I usually achieve this by
using
=SUBSTITUTE(²text²,²t²,²²)
Which returns ³ex² in a cell.

Unfortunately, this doesn¹t go well in VBA ...
Perhaps the followoing?

For j = 1 to len(str)
If Mid(str, j, 1) = "t"
Πdelete the letter of the string?
Else??

Any ideas? I¹m sure someone has done it before ...