JohnnieL's user avatar
JohnnieL's user avatar
JohnnieL's user avatar
JohnnieL
  • Member for 2 years, 6 months
  • Last seen more than 2 years ago
About

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
Badges
This user doesn’t have any gold badges yet.
This user doesn’t have any silver badges yet.
1
bronze badge
Posts

This user hasn’t posted yet.