Thread
:
Validation - clear blanks from drop down
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Hayley
Posts: n/a
Validation - clear blanks from drop down
The range is an array formula so I had copy it down enough rows to allow for
the largest number of items. So while the result is blank the cell has a
formula. So your suggestion didn't work.
--
Hayley
Reply With Quote
Validation - clear blanks from drop down