Excel
Thursday, November 24, 2016
how to work with the visible rows after applying autofilter
ActiveSheet.Range("$A$1:$J$5").AutoFilter Field:=2, Criteria1:="3"
Range("A2:A" & Cells(Rows.Count, "A").End(xlUp).Row).SpecialCells(xlCellTypeVisible).Copy _
Sheets("Email").Range("A30")
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment