Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop through Filtered Data
Is there a method to loop thorugh each row of a filtered data set? Should I
just copy the filtered data set to another sheet and run my loop there since the data will be in sequential rows? Thanks. Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop through Filtered Data
Dim rng as Range, rng1 as Range
Dim rng2 as Range set rng = activesheet.autofilter.range set rng1 = rng.offset(1,0).resize(rng.rows.count-1,1) On error resume next set rng2 = rng1.specialCells(xlVisible) On error goto 0 if not rng2 is nothing then for each cell in rng2 msgbox rng2.Address Next End if -- Regards, Tom Ogilvy "MJRay" wrote in message ... Is there a method to loop thorugh each row of a filtered data set? Should I just copy the filtered data set to another sheet and run my loop there since the data will be in sequential rows? Thanks. Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return filtered values into report worksheet based on filtered valueon the data worksheet | Excel Worksheet Functions | |||
MS2007 - deleting filtered data, deletes non-visible data too | Excel Discussion (Misc queries) | |||
Help to sort out filtered data from the data contained in another sheet of the same workbook | Excel Worksheet Functions | |||
For Loop in Filtered List | Excel Programming | |||
loop thru auto-filtered list | Excel Programming |