Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Regular Expression for cell address
Can someone explain this regular expression to me? I found it in some VBA
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what are the regular expression special characters while searching | Excel Discussion (Misc queries) | |||
Can someone help me with this regular expression? | Excel Discussion (Misc queries) | |||
Regular expression search/replace in Excel | Excel Discussion (Misc queries) | |||
Regular Expression | Excel Discussion (Misc queries) | |||
Regular expression searching problem | Excel Programming |