JohnnieL's user avatar
JohnnieL's user avatar
JohnnieL's user avatar
JohnnieL
  • Member for 2 years, 6 months
  • Last seen more than 1 year ago
Stats
215
reputation
3k
reached
0
answers
2
questions
Loading…
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.
2
silver badges
7
bronze badges
Top tags
0
Score
1
Posts
50
Posts %
0
Score
1
Posts
50
Posts %
0
Score
1
Posts
50
Posts %
0
Score
1
Posts
50
Posts %
0
Score
1
Posts
50
Posts %