| Title |
Test
Find
Pattern Title
|
| Expression |
(^[A-Z]{1,2}[0-9]{1,}:{1}[A-Z]{1,2}[0-9]{1,}$)|(^\$(([A-Z])|([a-z])){1,2}([0-9]){1,}:{1}\$(([A-Z])|([a-z])){1,2}([0-9]){1,}$)|(^\$(([A-Z])|([a-z])){1,2}(\$){1}([0-9]){1,}:{1}\$(([A-Z])|([a-z])){1,2}(\$){1}([0-9]){1,}$) |
| Description |
A regular expression for any valid MS Excel range |
| Matches |
A1:BB10 | $A1:$BB10 | $A$1:$BB$10 |
| Non-Matches |
$A1:BB10 |
| Author |
Rating:
Not yet rated.
Thanassis Viennas
|
| Source |
|
| Your Rating |
|
Title: cells are valid with preceding zeros!
Name: Thanassis Viennas
Date: 6/9/2005 6:10:51 PM
Comment:
Cell row ids are still valid while preceded with zero!(e.g. $A01)
