Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating values using advanced filter - VBA
Hi Group-attendees
I've got worksheets with +30.000 rows, in one column I need to fill in values based on several criteria, for that I use Advanced Filter(s) and subsequently loop through all rows. If the row is not Hidden, then the column is updated. here is part of the code: Range("A1").CurrentRegion.AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _ Range("SelectSLA"), Unique:=False Range("Q1").Select For RData = 2 To ActiveSheet.UsedRange.Rows.Count If Not Rows(RData).Hidden Then Range("Q" & RData).FormulaR1C1 = SLA(Rsla, UBound(SLA, 2)) End If Next But this code is very slow. Does anyone know a faster way, to do this. I need to repeat this section with 30-75 different criteria (=Range("SelectSLA")) /Tommy, DK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
Advanced Filter for Values in Column M greater than Values in Colu | Excel Discussion (Misc queries) | |||
advanced filter macro to locate values via multiple criteria | Excel Programming | |||
Advanced Filter - Unique Values | Excel Programming | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |