How exactly are you trying to "validate" this data? Formulas? Built-in
functions? Please be more specific and we can come up with something for
you.

"Emece" wrote in message
...
Is there a way to omit blanks when validating data from a list?

I am using a list that have blank cells in it, and when using this list in
other sheet I don't want this blank cells to be displayed.

I guess I should use a macro to do this, but can´t figure it out. Any help
would be aprreciated.

Thanks in advance

Emece.-