title: VBA Find row number of first visible row after filter
body: <p>I am attempting to get the row number of the first visible row after I filter the data. I need the row number so I can select the top cell in that respective row to select all cells below the active cell. I am very much a beginner to VBA so I'm not familiar with essentially any of it.  </p>
  
  <p>Here's the example of the code I need to modify:</p>
  
  <pre><code>Dim bidNum As String
  Dim bidFull As String
  
  bidNum = "123" 'sample number
  bidFull = "Bid-" + bidNum + ".csv"
  
  ActiveSheet.ListObjects("PriceExp").Range.AutoFilter Field:=1, Criteria1:=bidFull    'filters data by Bid #
  
  Range("B####", Range("B####").End(xlDown)).Value = "sample name" '#### is where I need to know the current row number after data is filtered
  Range("C####", Range("C####").End(xlDown)).Value = "sample state"
  'etc. for more columns
  </code></pre>