Thread: [Solved] Select first NOT hidden row in table
View Single Post
 
Old 11-28-2021, 02:37 PM
trevorc trevorc is offline Windows 7 32bit Office 2013
Competent Performer
  
Join Date: Jan 2017
Posts: 174
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default Select first NOT hidden row in table
Hi All,
Trying to get this going, i have code that works fine if i debug and select the first row in a table that has hidden rows, then continues ok.

I need code that after i have filtered my records to select the first row that is not hidden in my table. This what i have so far...

Code:
    Ass_Num = Intersect(acrow, tblColumns("Asset" & Chr(10) & "Number").Range)
    Sheets("backup").Select
    With ActiveSheet
    .ListObjects("Customers").Range.AutoFilter Field:=6, Criteria1:=Ass_Num ' filters rows, but the table looses the focus

        firstRow = .AutoFilter.Range.Offset(1).SpecialCells(xlCellTypeVisible).row ' this works on another table because its not filtered and the table has the focus
        Range("A" & firstRow).Select
    End With
Reply With Quote