Select first NOT hidden row in table

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Select first NOT hidden row in table

FAQ

Thread Tools

Display Modes

11-29-2021, 07:04 AM

NoSparks

Windows 10 Select first NOT hidden row in table

Office 2010

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Another option might be to deal with the table only and bypass the header row when looking for the visible rows after filtering.

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
    Set fRng = .ListColumns(1).DataBodyRange.Cells.SpecialCells(xlCellTypeVisible)
    fRng.Cells(1).Select
    '.Range.AutoFilter
End With

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Looking to copy select cells in table using dropdown list to paste to new table in another worksheet	CaptainRetired	Excel Programming	18	01-04-2018 07:22 PM
Find first row in a table that is not hidden?	Officer_Bierschnitt	Excel Programming	5	10-31-2015 09:42 AM
programmatically inserting hidden text into a Word 2010 table	epid011	Word VBA	16	12-30-2013 11:29 AM
Hidden text in table	Angel9520	Word Tables	1	05-02-2012 01:00 AM
Select Text in Table but Table Gets Selected Too	RBusiness	Word	1	06-07-2011 04:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:58 AM.