<div>
Without a workbook to look at, try<br />
<br />
=OFFSET(End2EndTime!$A$1,0<wbr />,0,COUNTA(<wbr />End2EndTim<wbr />e!$A:$A),1<wbr />)
</div>


Without a workbook to look at, try

=OFFSET(End2EndTime!$A$1,0,0,COUNTA(End2EndTime!$A:$A),1)

<div>
This actually worked the best, however I had to use -4 to get rid of the unwanted line items at the bottom of the combolistbox... &nbsp;Worked well to keep the dynamic combolistbox populated. &nbsp;Thanks.
</div>


This actually worked the best, however I had to use -4 to get rid of the unwanted line items at the bottom of the combolistbox...  Worked well to keep the dynamic combolistbox populated.  Thanks.

<div>
<div class="content wysiwyg-content">
I am using the following formula in the Name Manager on a list that I use to populate a combobox in a userform.<br />
<br />
=OFFSET(End2EndTime!$A$4,1<wbr />,0,COUNTA(<wbr />End2EndTim<wbr />e!$A:$A)-1<wbr />,1)<br />
<br />
for some reason it is grabbing the whole list, plus two more extra blank rows that are under the list?? &nbsp;I was going to submit a question on how to eliminate the row that is on the bottom of the list &quot;TOTAL&quot;, but now the question is how do I eliminate the bottom three rows because I have to include those extra two blank rows that the list has, plus the one that says TOTAL?<br />
<br />
Any ideas how to remove from the bottom of a define list? &nbsp;I do not want to have to recreate the list in a different spot.<br />
Thanks.
</div>
</div>


I am using the following formula in the Name Manager on a list that I use to populate a combobox in a userform.

=OFFSET(End2EndTime!$A$4,1,0,COUNTA(End2EndTime!$A:$A)-1,1)

for some reason it is grabbing the whole list, plus two more extra blank rows that are under the list??  I was going to submit a question on how to eliminate the row that is on the bottom of the list "TOTAL", but now the question is how do I eliminate the bottom three rows because I have to include those extra two blank rows that the list has, plus the one that says TOTAL?

Any ideas how to remove from the bottom of a define list?  I do not want to have to recreate the list in a different spot.
Thanks.

Dynamic List defination used in a Userform (ComboListBox).

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.