ChangeIntegerToLong

Changes 16-bit (max value 32,767) Integer declarations to use 32-bit (max value 2,147,483,647‬) Long integer type instead.


This feature is currently only available in pre-release builds (or the xmldoc asset doesn’t yet exist on master!).

This quickfix addresses the selected inspection result, but can also be applied to all similar inspection results in the following scopes (as a single operation):

  • Procedure
  • Module
  • Project

Examples

Each example is a self-contained MCVE showing the feature in a single specific scenario.

Standard Module
Named Module1 by default, these are general-purpose standard procedural modules.
Class Module
Named Class1 by default, these modules define the default interface for an object of that type.
Predeclared Class
A class module with its VB_PredeclaredId attribute set to True (with or without a @PredeclaredId annotation).
Interface Module
Abstract interfaces are class modules (with or without an @Interface annotation) whose default interface is not a class type intended to be instantiated.
UserForm Module
A predeclared class with a design-time visual designer using the MSForms UI framework.
Document Module
Owned by the host application, these class modules belong to the host document and may handle various events fired by the host application.

Module1 (before)

Public Sub DoSomething()
    Dim row As Integer
    row = Sheet1.Range("A" & Sheet1.Rows.Count).End(xlUp).Row
    Debug.Print row
End Sub

Module1 (after)

Public Sub DoSomething()
    Dim row As Long
    row = Sheet1.Range("A" & Sheet1.Rows.Count).End(xlUp).Row
    Debug.Print row
End Sub

Back to list

The content of this page was generated from xml/comments in the source code compiled into Rubberduck.CodeAnalysis.xml. Edit this page