View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fletch[_2_] Fletch[_2_] is offline
external usenet poster
 
Posts: 1
Default Validate Excel Range with RegEx

Any thoughts on how to validate an Excel range with RegEx?
Acceptable inputs would include $A1:$BD25, C:C, B4 etc.
I'm close to coming up with an answer but I'm not sure how to stop
invalid range references such as C3:A2 from being accepted.

Thanks.