Select range cells with blank rows <p>I've been having difficulties with figuring out how to code this select range macro to include blank rows. The worksheet is a chart with variable number of columns and rows. This is what I have so far:</p> <pre><code>Sub Macro1() Range("A5").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy End Sub </code></pre> <p>The selection step in the macro will only go so far as that blank row and won't go any further (obviously because it's blank hehe). For that reason, I tried adapting this discontiguous type of code but with no luck:</p> <pre><code>Sub SelectRangeDown_Discontiguous() Range("A5", Range("A65536").End(xlUp)).Select End Sub </code></pre> <p>I was hoping someone could help me figure out the best way of writing this code? Am I on the right path?</p>