Posted to microsoft.public.excel.programming

Fletch[_2_] Fletch[_2_] is offline

external usenet poster

Posts: 1

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
automated cut and paste using regex	excel_newbie	Excel Worksheet Functions	2	March 20th 09 12:29 PM
validate a date range	tikchye_oldLearner57	Excel Discussion (Misc queries)	4	March 13th 07 01:17 AM
Validate date within range prior to calculation	Natassja	Excel Discussion (Misc queries)	1	January 24th 06 05:52 PM
Regex Question	William Barnes	Excel Programming	5	January 2nd 04 11:57 AM
regex string matching	Jamie Martin[_2_]	Excel Programming	3	September 26th 03 09:28 PM

All times are GMT +1. The time now is 10:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us