Use the programmer’s text editor (I use UltraEdit) and do a bulk search of your project source directories.
Start by looking for Variant (obviously), although you probably already did.
Next, use a regular expression type search for something line by line:
*Dim [a-zA-Z][a-zA-Z0-9_]*\p
This should get a Dim x script without an end As DataType .
Use *Dim [a-zA-Z][a-zA-Z0-9_]*,.* To search for script types Dim a, b, c As Integer .
Use *Dim .*, [a-zA-Z][a-zA-Z0-9_]*,.* For scenarios with an odd ball, for example Dim a As Integer, b, c As Long
Repeat the above bindings with Private and Global instead of Dim , and this should get almost everything.
tcarvin
source share