View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter[_21_] Peter[_21_] is offline
external usenet poster
 
Posts: 35
Default 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