Locates unqualified Workbook.Worksheets/Sheets/Names member calls inside workbook document modules that implicitly refer to the containing workbook.
New This feature is currently only available in pre-release builds (or the xmldoc asset doesn’t yet exist on main
!).
Inspection type: CodeQualityIssues
Default severity: Warning
Implicit references inside a workbook document module can be mistakes for implicit references to the active workbook, which is the behavior in all other modules By explicitly qualifying these member calls with Me, the ambiguity can be resolved.
This inspection will only run if the Excel library is referenced.
The following quick-fixes are available for this inspection:
Each example is a self-contained MCVE showing the feature in a single specific scenario.
Module1
by default, these are general-purpose standard procedural modules.Class1
by default, these modules define the default interface for an object of that type.VB_PredeclaredId
attribute set to True
(with or without a @PredeclaredId
annotation).@Interface
annotation) whose default interface is not a class type intended to be instantiated.
The content of this page was generated from xml/comments in the source code compiled into Rubberduck.CodeAnalysis.xml
.
Edit this page