Re: $$Excel-Macros$$ Data validation not working properly

2011-12-06 Thread Rohan
Ensure that you are using the correct formula and remove unnecessary blanks from the sheet. Also, check the Ignore blanks in data vlaidation box. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

Re: $$Excel-Macros$$ Data validation not working properly

2011-12-03 Thread rajan verma
Remove check from Ignore Blanks in data validatoin On Sat, Dec 3, 2011 at 7:20 PM, dguillett1 wrote: > Try removing blank cells in your defined name list or ' ' ' > > > > Don Guillett > SalesAid Software > dguille...@gmail.com > -Original Message- From: B Sharma > Sent: Friday, December

Re: $$Excel-Macros$$ Data validation not working properly

2011-12-03 Thread dguillett1
Try removing blank cells in your defined name list or ' ' ' Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: B Sharma Sent: Friday, December 02, 2011 10:52 PM To: MS EXCEL AND VBA MACROS Cc: rajanverma1...@gmail.com Subject: $$Excel-Macros$$ Data validation