Dynamic named list includes blank cell at bottom

L

L Scholes

I am using the following to create a dynamic list:

=OFFSET(LookupLists!$A$2,0,0,COUNTA(LookupLists!$A:$A),-1)

The problem is, it always adds the blank cell at the bottom of the list
that is also included in the combobox. How do I modify this so it does
not include the blank cell at the bottom? (I have a header above the
list in A1 that I do not want included in the list - it is currently
not included.)

Thanks in advance.
 
L

L Scholes

Nevermind, got it!
=OFFSET(LookupLists!$A$2,0,0,(COUNTA(LookupLists!$A:$A)-1),-1)
 
Top