205
reputation
1

JohnnieL
Loading…

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
  • Member for 2 months
  • 0 profile views
  • Last seen May 20 at 11:31