ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Replace Function (https://www.excelbanter.com/excel-programming/272198-replace-function.html)

Chip Pearson

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.





Yossi

Replace Function
 
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.




All times are GMT +1. The time now is 05:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com