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