Remove Header/Title from list

  • Thread starter Thread starter DarS
  • Start date Start date
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?
 
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
 
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,
 
Back
Top