Hi guys !
I hide rows on my sheet using the autofilter method. Then I wanna loop through ONLY the visible rows (to use the information they contain).
I know I could loop through all rows and use the .hidden property to find them but I'm looking for a faster way since my sheet contains close to 6000 rows.
There must be a way...maybe with the specialcells method ??
Thanks