Dynamic named list includes blank cell at bottom
 

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.

Dynamic named list includes blank cell at bottom
 

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