title: Stop blank cells entering into listbox
body: <p>I have a listbox which is populated with a range of cells but unfortunately some of the cells are blank. In some cases my listbox is getting populated with a large number of cells so it would not be practical to enter each cell manually. Below shows the line of code that populates the listbox:</p>
  
  <pre><code>Me.ListBox1.List = Sheets("List Names").Range("C1022:C1200").Value
  </code></pre>
  
  <p>but I need a way to loop through the cells and only add cells that have information in them, or is that even possible. Thanks in advance.</p>