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-28-2021, 02:45 PM

Logit

Windows 10 Select first NOT hidden row in table

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

Does this work :

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

     Columns(1).Cells.SpecialCells(xlCellTypeVisible).Cells(1).Select

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 03:12 AM.