replacerx to turn Excel column reference into finite range

[Gintaras]

Macro

Code:

Copy      Help

str s="$A:$BZ"
s.replacerx("^(\$A):(\$BZ)$" "$1$$1:$2$$55555")
out s

In replacerx, the first string is regular expression (rx), the second - replacement.

In rx:
^ - beginning
() - remembers the enclosed part
\$ - $ (because $ is special symbol, it is with \)
$ - end

In replacement:
$1, $2 - first and second remembered parts
$$ - $ (in replacement, $ is special symbol, and $$ is its escape sequence)