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
|