VBA 97 does noet have Replace: anything similar ?
 

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

VBA 97 does noet have Replace: anything similar ?
 

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

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


--
Regards
Frank Kabel
Frankfurt, Germany


Peter wrote:
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