Tools>Options>Editor Tab>Put check next to require variable declaration>click ok.
Just like if you...
Dim I As Integer
In a lot of subs for looping but then make the mistake of doing
Dim i As Integer
Someplace, they all change to the lower case
Glad you have posted this thread as solved which I hope means you have this figured out.
Good Luck
vb5prgrmr
Posting Virtuoso
1,912 posts since Mar 2009
Reputation Points: 156
Solved Threads: 296