Replace Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have developed a spreadsheet utilising vba in excel XP. I now discover that the Replace function does not exist in excel 97. I am using the replace function like this

variable1 = Replace(variable2, "text1", "text2"

What code can I use to have the same effect and function in excel 97 and XP?
 
One way:

variable1 = Application.Substitute(variable2, "text1", "text2")
 
You must log in or register to reply here.

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

Concatenate Macro 5
How do you send data to the same row of a text file everytime? 3
Excel 97 replace vs newer versions... 2
Replace Function in Excel 97 6
Search/replace Userform Variable 6
Replace in Excel 97 2
Problems with Excel 97 and XP 1
Code error message for Excel 97 users 6

Back
Top