VBA Mantra

• Never use Find/FindNext - there's always a better way - Dictionary object
• Always use [Option Explicit]
• Always fully qualify range [Range/Cells/Sheets/Worksheets/Workbooks], only use Select if you are doing UI
• Dim a, b as integer - a is Empty not integer
• Always try Application.Worksheetfunction. ... first
• Loop through ranges with For Each
• AutoFilter plus `Range.SpecialCells(xlCellTypeVisible) is super helpful
• When its too slow Application.ScreenUpdating=False