Hi Guys. I have a pulldown menu created that refers to info within
another worksheet. In the Listfillrange it looks up A1:A10....i want
to add more cells to this but are A39,A40 etc (don't want the cells
inbetween to show up in this menu) I thought using a '+' would do it
but as soon as i click off it the range disappears.

Any ideas?