Remove spaces between items in a dropdown list

  • Thread starter Thread starter Michael Lanier
  • Start date Start date
M

Michael Lanier

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
 
Hi,

If the list is getting these from a range, just rearrange the range in the
order you wish.
 
Back
Top