Replace Function

C

Chip Pearson

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 (e-mail address removed)
 
Y

Yossi

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.
 

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

How do I change the forecolor of a CheckBox when True 2
Worksheet functions in VBA 2
Browser Functions Problem 7
FreezePanes on a Row without using an ActiveWindow object 1
How can I store both key and value in VBA? 1
Disable Range Selection Change 3
Range missing its target area weirdly 5
How do i get cumilative sum of values against specified criteria? 1

Top