A AhujaA Joined May 14, 2012 Messages 21 Reaction score 0 May 22, 2012 #1 Hi, I'm using a named range for data validation, but the range may contain some blanks in it. How can I remove these blanks without changing my named range? Help plz.
Hi, I'm using a named range for data validation, but the range may contain some blanks in it. How can I remove these blanks without changing my named range? Help plz.