False Negative Check of Variable not declared Or "is there any check for missing "foreign / not Local" Variables / Constants

[elRicharde]

Hi, as I´m doing a big Refactoring, it would be very helpful if any Check could find undeclared, unlocal Variables.

• I do have an Worksheet wicht CodeName Tabelle3 which has no Code
• I do have 2 Modules
  • ModGen, which is Empty Except Option Explicit Statement
  • Modul4, which Contains the following Code:

Option Explicit

Public Sub Foo()
    Dim myArray As Variant
    Dim myLong As Long
    
    Set myArray = Tabelle3.Range(Tabelle3.Cells(ModulGen.RowStart, ModulGen.ColStart), _
                                 Tabelle3.Cells(ModulGen.RowEnd, ModulGen.ColEnd)).Value
                                 
    'if one of the 4 Constants RowStart, RowEnd, ColStart, RowEnd are not declared, 
    'Rubberduck still will not find these errors in any Syntax check
    
    myLong = ModulGen.RowStart
    'also no error occurs in inspections of RD
End Sub

Is there any check that would find these Errors in Rubberduck?
If I try to run the Sub, Excel brings the error "Compile Error - Object not Found", but if i run another Sub in Modul4, these Check is not done.
As my Coding is a lot, I don´t want to miss anything and would be great full for a Solution here. As Excel finds the error at Runtime, I Hope RubberDuck can find it before as well.

p.s.: With Excel VBE Debug -> Compile [Project] i seem to cover the whole code for these error, it is step by step and not a s List as in Rubberduck, but better than nothing. Other Suggestions are very welcome.

Thanks for your Help and best Regards
Richard