String operations in VBA for "Substituite"?

  • Thread starter Thread starter Brad Patterson
  • Start date Start date
B

Brad Patterson

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 ...
 
Hi Brad,

If you're using Excel 2000 or later, check out the VBA Replace function.
In Excel 97 you can use the SUBSTITUTE worksheet function via
Application.WorksheetFunction.Substitute.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
vba Function code 1
VBA for All cells in workbook 5
Bold items within text string 7
Scrabble Value calculation for Welsh words 0
formatting text 4
Assigning the name of a userform/control to a changing string 2
Delete rows based on contents of Col A 0

Back
Top