05-28-2009, 08:22 PM
Dealing with Excel 03 and 07 a lot of time I have to convert a columns reference to a finite range.
I cannot figure out how to use replacerx to do this (I am new to replacerx)
Replace: $A:$BZ
With: $A$1:$BZ$55555
Where: A and BZ are any letters and may be 1 or 2 in a row. (as above)
I cannot figure out how to "remember" and return ":$BZ" to add the 55555 after it with replacerx
The Help for replacerx mentions nothing about it.
Regexp help mentions it but I cannot figure out the syntax.
If you can help please explain the basics of the remember feature (and how to code the example) I'd really appreciate it
thanks
I cannot figure out how to use replacerx to do this (I am new to replacerx)
Replace: $A:$BZ
With: $A$1:$BZ$55555
Where: A and BZ are any letters and may be 1 or 2 in a row. (as above)
I cannot figure out how to "remember" and return ":$BZ" to add the 55555 after it with replacerx
The Help for replacerx mentions nothing about it.
Regexp help mentions it but I cannot figure out the syntax.
If you can help please explain the basics of the remember feature (and how to code the example) I'd really appreciate it
thanks