Hi all
I am rather new to VBA, but with stuttering steps I've managed to push through my problems so far, except for this one:
I have an Excel file that has about 3000 lines of information, and each line has 8 fields (columns). The lines that I want have certain common fields between them, so I first used an autofilter to get the lines I'm interested in, like so:
Selection.AutoFilter Field:=6, Criteria1:="Technical"
Selection.AutoFilter Field:=8, Criteria1:="<>"
This hides a good 90% of the lines, and the remaining 300 or so that match the autofilter criteria stay visible. My next step is to take the information from the first column of every line that remains with the autofilter in order to treat those values elsewhere. So, my question is this: Is there a way to treat only visible lines and not hidden ones? My reason for using the autofilter first is to speed up the process - I assume it's faster than using IF's to sort through every single one of the 3000 lines.
Thanks
[EDIT] I've just found that I can use If Not .Rows(rowNumber).Hidden, but I still have to search through every line using that...
Bookmarks