Remove Header/Title from list

D

DarS

I have several lists created and use them for pull downs on various sheets.
I would like to eliminate the title row such as "Column 1". I have added my
own titles instead of "Column 1" but would prefer no header as this becomes a
valid selection in the pull down. Any suggestions?
 
G

Gary''s Student

You can have your cake and eat it:

Rather than start you validation pull-down at the top of a column (H1 thru
H30 for example), use H2 thru H30
 
D

DarS

Thanks that works until I populate the sheet referenced by the pull downs
again with data from Access. Then row 2 contains the title.

But thanks for the tip. I will try a few other things incorporating your
suggestion and see if I can make it work.

Thanks again,
 
Top