Hi,
Thanks in advance for any advice on this Excel 2003 issue I'm having.
I have a named range which I am using as a data validation in a drop down list. It is a list of columns in a table converted from a number to a letter
The named range changes if users add their own columns. (eg if they add two columns the valid selection may go from columns H to R to columns J to T
When I hide the named list, the drop down list selection is blank, although if I 'select' one of the 'blanks', it actually comes up with a 'valid' column!
Can anyone tell me why the drop down list goes blank even though it validates properly?
I have other lists where hiding the named range still allows me to see the valid data in the drop down.
Bookmarks