Remove spaces between items in a dropdown list
 

I have dropdown lists (Data Validation List) that reflect spaces
between items. A list with the range of A1:A6 before zeros are hidden
may look like this:

Apples
Oranges
0
0
Lemons
0

I would like for the list to look like this:

Apples
Oranges
Lemons
0
0
0

Can someone suggest a macro for this? Thanks.

Michael

Remove spaces between items in a dropdown list
 

hidden rows will still appear in your validation dropdown

you could delete the rows with zeros. or copy the 'good' names to a new
table and use that in your validation

"Michael Lanier" wrote in message
...
I have dropdown lists (Data Validation List) that reflect spaces
between items. A list with the range of A1:A6 before zeros are hidden
may look like this:

Apples
Oranges
0
0
Lemons
0

I would like for the list to look like this:

Apples
Oranges
Lemons
0
0
0

Can someone suggest a macro for this? Thanks.

Michael