There are named ranges involved and they are on a different sheet in the same
workbook. The lists are generated from a SQL query and the header comes
along. When the lists were created, the box for headers was checked. I have
tried changing the range for the names ranges but unsuccessfully so far. I
am not sure if that answers your question or not...

"Conan Kelly" wrote:

bburnett,

Where is this list at (what are the cell addresses for this the range of
this list)? Is this list for data validation on the same sheet or a
different sheet? Are there named ranges involved?

Can't you just adjust the address of the DV's Source range to exclude the
cell the column header shows up in?
Select the cell that has the DV drop down list, then: Data Validation...
Settings tab Source: box.

HTH,

Conan




"bburnett" wrote in message
...
I have created a database query (sql) to import data into a list that I
want
to use for a drop down list. However, the column header appears as one of
the list's items. Is there a way around this? Would the combo box be a
better approach? Thanks for any assistance.