Populating a ListBox

[ToddG]

I'm sure this is probably pretty simple, but how do I
populate a ListBox with only the populated cells in a
worksheet?

For example:

Column A Column B Column C Column D
2.3 45 23.98 43.981
90 45.877 32.2 3

The ListBox would show all of these numbers using the
first row as column headers. The number of rows is
different everytime, that's why I can't just specify a
range within the ListBox.

Any help would be appreciated

 

[Dave Peterson]

But you could use a dynamic range name if you could pick out a column that
always has data in it:

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

You can read more about this at Debra Dalgleish's site:
http://www.contextures.com/xlNames01.html#Dynamic