Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping through visible rows only
I run through the rows of a sheet using this code:
---------------------------------------------------------------- i = 1 Do If Not Range("b" & i).EntireRow.Hidden then ' Do commands End If i = i + 1 Loop Until range("a" & i) = "" ---------------------------------------------------------------- Isn't there a FASTER way of going to the next VISIBLE row ? - Because if only 5 rows are visible (using autofilter) in a sheet of 25,000 rows then the above code is a waste of time and takes too long. Please note; I would like to AVOID actually ACTIVATING any cells. I was thinking using this line; Range("j" & (i)).Offset(1,0) in combination with the SpecialCells & xlCellTypeVisible commands, but how ? Please help! (c: Rasmus |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count rows in a column for looping | Excel Discussion (Misc queries) | |||
looping through rows and columns | Excel Discussion (Misc queries) | |||
Looping a selection of rows | Excel Discussion (Misc queries) | |||
Looping through Ranges of Rows | Excel Programming | |||
Looping through Ranges of Rows | Excel Programming |