Dynamic Range

[Noz2k]

So I have some named ranges, which are used for userform combobox lists. I want to make it so that the user can add to these ranges by just posting a value in the row below in a column.

I have tried using this code in Refers to:

=OFFSET(LookupLists!$E$4,0,0,COUNTA(LookupLists!$E:$E),1)

Whilst it works dynamically it also returns a blank value at the bottom, any idea why this is, or how to prevent this?

 

[njimack]

Do you have a header at the top of your column? If so, try the following:
=OFFSET(LookupLists!$E$4,0,0,COUNTA(LookupLists!$E:$E)-1,1)

 

[Noz2k]

Works perfect, thanks