Remove Header/Title from list
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,
--
Dar
"Gary''s Student" wrote:
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
--
Gary''s Student - gsnu200796
"DarS" wrote:
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?
--
Dar
|