I am using... the following code to scan 52 sheets completely for the number 85099055 and if it finds that number to sum up the 7 values to its right of where it was found on each sheet.
Works great, however once the sheet contains about 20k plus of other values it slows down to a grind, is there a way to speed this up dramatically... If it helps the Range can be reduced to just B8:B60, G8:G60 AND V8:V60 and the number will not be on every sheet and if it is will just appear once per sheet. Thanks
Number = 85099055
For Idx = 1 To 52
Set c = .Find(Number, .Cells(.Rows.Count, .Columns.Count), lookat:=xlWhole)
If Not c Is Nothing Then Total = Total + WorksheetFunction.Sum(c.Offset(0, 2).Resize(1, 7))