Hi everyone,
i made a VBA code and its taking to much time ..may you please make it faster this code
i have 100000 rows and 11 columns
i made a VBA code and its taking to much time ..may you please make it faster this code
i have 100000 rows and 11 columns
Code:
x = 3
Do Until Sheets("Tracker").Range("B" & x).Value = ""
Sheets("Tracker").Range("L" & x).Value = Application.WorksheetFunction.CountIfs _
(Return_1, Sheets("Hide").Range("A2"), IDrng, Sheets("Tracker").Range("B" & x)) _
If Sheets("Tracker").Range("L" & x).Value <> 0 Then
Sheets("Tracker").Range("L" & x).Value = Application.WorksheetFunction.SumIfs _
(total, Return_1, Sheets("Hide").Range("A2"), IDrng, Sheets("Tracker").Range("B" & x))
Else
Sheets("Tracker").Range("L" & x).Clear
End If