title: Selecting columns that have values in Excel Macro (range object in VBA)
body: <p>How do I modify this line in VBA to only select the columns that have values?</p>
  
  <pre><code>Set rng = Range("A1", Range("A65536").End(xlUp)).SpecialCells(xlCellTypeVisible)
  </code></pre>
  
  <p>I don't think I'm doing something right since the <code>CountLarge</code> property is several billion cells </p>
  
  <p>Here is a sample of my data</p>
  
  <p><img src="https://i.stack.imgur.com/ysSjT.png" alt="enter image description here"></p>