Hello,

I just discovered a way to make a dynamic list range and store it as a "Name".
I know how to use it in a drop-down list, but how can I do the same with a ComboBox ?

Can I call the name as the ListFillRange, or do I have to write the full Name formula ?

---
If you are interested, here is the formula :
=OFFSET(Sheet1!$A$1;0;0;COUNTA(Sheet1!$A:$A);1)
Considering the list content starts in A1 and is contained in the whole column
---

Thank you for your help !

François