Data Validation Removing blanks

Joined
May 14, 2012
Messages
21
Reaction score
0
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.
 
Back
Top