Thread: Replace Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neil[_14_] Neil[_14_] is offline
external usenet poster
  
Posts: 29
Default Replace Function
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?
Reply With QuoteReply With Quote