ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combo box - Listfillrange (https://www.excelbanter.com/excel-discussion-misc-queries/150086-combo-box-listfillrange.html)

[email protected]

Combo box - Listfillrange
 
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?



All times are GMT +1. The time now is 12:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com