Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ignore blanks in dropdown
hi,
i have a dropdown box in my sheet. not in a userform. the input range is like F7:F77 but there are some cells which are blank. how can i get it to ignore those blank cells so that i do not have a bunch of blank values to select from the dropdown box. i would NOT Llke to resort column F is at all possible so that the blank values appear at the bottom. but if this is not possible, then any other way you would recommend would be apreciated. thanks in advance, geebee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Median - Ignore blanks | Excel Discussion (Misc queries) | |||
Ignore Blanks | Excel Discussion (Misc queries) | |||
Ignore Blanks in Data Validation | Excel Worksheet Functions | |||
USING IGNORE BLANKS IN FORMULA | Excel Discussion (Misc queries) | |||
Ignore Blanks | Excel Programming |