title: Select visible rows after autofilering
body: <p>I have autofiltered and I want to select rows which are not hidden, also if there is only one row I have to select only that row.</p>
  
  <p>I'm stuck with a statement kindly help me out, the code is running but it is going to else statement even though the if statement is true, the code I have written is </p>
  
  <pre><code>If ActiveCell.Value ="" Then
  Else
      ActiveCell.EntireRow.Select
  
      If ActiveCell.Offset(1, 0).Value = "" then 
          Do Until ActiveCell.Offset(1, 0).EntireRow.Hidden = False
          Loop
      Else
          Range(Selection, Selection.End(xldown)).Select
      End if
      Selection.Copy
  End if
  </code></pre>