M

#### M. Authement

code for finding/altering a cell address within a string. I put spaces in

to break the expression apart into the parts (I think) I understand.

(?:[\^\])-/+*:,="[(]) (\$?) ([A-Z]{1,2}) (\$?) (\d{1,5}) ([^\d]|$)

The second and fourth part are the optional absolute/relative dollar sign,

the third part is the one or two character column, and the fifth part is the

1 to 5 digit row number.

What are the first and last parts of this expression?

Is there a more robust way to designate the row number as 1-65536?

What about the column designation? I was thinking something like

([A-Za-z]|[A-Za-z][A-Za-z]|[Ii][A-Va-v]). This allows for lower case

letters and avoids the possibility of columns greater than IV.

I am new to regular expressions, having read an online tutorial, so any

references to sources of help are also appreciated. Thanks in advance for

your help!