View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Replace Function

Yossi,

The VBA Replace function didn't exist in 97; it was added in 2000.
The REPLACE worksheet function has the same syntax in all
versions. Perhaps you could provide a few more details and example
code to illustrate the problem you are having.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Yossi" wrote in message
...
Hello,
I have a big problem with 'Replace' function.
I got a workbook that contains vba code that was writen in

Office 97.
I need to change it to Ofice XP.
The syntax of the Replace function is not similar.
Please Help Me.
Thanks.