VBA 97 does noet have Replace: anything similar ?

[Peter]

I have som code that includes this piece of work:

Beginadres = Replace(Cells(Range("RyInd").Value, 2).Address, "$", "")

In short: I need to store the address of the cell found as a string without
the "$"-signes.

Unfortunately I was not thinking right: I wrote this code in VBA/Excel2003
and it must run in VBA/Excel 1997 (at work, soon to become 2000, but still).
Guess what, it didn't run... How do I work around this efficiently ?

Many thanks,

Peter

 

[Frank Kabel]

Hi
one way:
use
application.worksheetfunction.substitute(....)

or see:
http://www.dicks-blog.com/excel/vba_code_library/index.html
and search for Replace97