Re: Validation of User Data Entry of Excel Range Address
From: Ragdyer (RagDyer_at_cutoutmsn.com)
Date: 09/05/04
- Next message: carolfil: "Re: How do I print gridlines for blank columns"
- Previous message: anonymous_at_discussions.microsoft.com: "Sum of Degree Angles"
- In reply to: Rick Grieser: "Validation of User Data Entry of Excel Range Address"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 5 Sep 2004 13:57:04 -0700
This worked for me:
=AREAS(INDIRECT(G3))>0
-- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Rick Grieser" <anonymous@discussions.microsoft.com> wrote in message news:05d301c49355$dfc80f30$3501280a@phx.gbl... > I am trying to use Excel's Data Validation feature to > validate whether or not a user has entered a valid excel > range address. Does anyone know the proper validation > formula? > > Ex. User Data Enters A3:B4 into Cell G3. The validation > feature would allow the data entry into Cell G3. > > User Data Enters A3:XX7 into Cell G3. the validation > feature would NOT allow the data entry into Cell G3 since > XX7 is an invalid range address. > > Thanks for your help.
- Next message: carolfil: "Re: How do I print gridlines for blank columns"
- Previous message: anonymous_at_discussions.microsoft.com: "Sum of Degree Angles"
- In reply to: Rick Grieser: "Validation of User Data Entry of Excel Range Address"
- Messages sorted by: [ date ] [ thread ]
