Mathieu Guindon

It's very easy to handle a worksheet's `Change` event (or a workbook's `SheetChange` event), and cause accidental recursion: ```vb Private Sub Worksheet_Change(ByVal Target As Range) 'any code that modifies any...

Because of what appears to be a bug in the VBA runtime (compiler?), `Variant` variables can cause logical errors when they are compared and hold different runtime types - that's...

We need an inspection that suggests replacing this: DoSomething 42, , , , , , , True, , , False With named arguments. DoSomething line:=42, isFoo:=True, isBar:=False Currently blocked by...

The grammar doesn't enforce maximum identifier lengths (see #2855), yet we assume that no parser error means the code is compilable. We need an error-level inspection result to pop for...

Object reference could be held by With block

2

A *language opportunity* inspection: ````vb Dim something As Object Set something = New Object With something .Foo = 42 Debug.Print .Bar End With ```` If a local variable is only...

Inspection for redundant variable initializations

1

If a variable's first assignment (taking code paths into account) is a literal with the default value for that variable's declared type, Rubberduck should suggest removing that redundant assignment. ````vb...

Signature mismatch inspection

5

Sometimes an event handler signature can be typed manually: ````vb Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) If CloseMode = vbFormControlMenu Then Cancel = True Hide End If End...

The *Search Results* toolwindow needs a way to copy a tab's contents to the clipboard.