| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dropdown list contains 5 items want to add 100 how | Excel Discussion (Misc queries) | |||
| dropdown list contains 5 items want to add 100 how | Excel Discussion (Misc queries) | |||
| How do I associate calculations with items in a dropdown list? | Excel Programming | |||
| is it possible to re-size or format list items in dropdown box? | Excel Discussion (Misc queries) | |||
| dynamic list to remove duplicates and spaces ? | Excel Programming | |||
Threaded Mode
