Minimum Length of Variable Name

[Don Wells]

Running Office 2003

I was surprised to discover that the following code does not throw an error until line 30'.

Code: Select all

Option Explicit

Public Sub kkk()

10    K = ThisWorkbook.Path
20    L = K
30    LA = ThisWorkbook.Path

End Sub

Is it common that a variable named with a single character, escape testing by the compile process? Or is my machine acting up?

[HansV]

Are you sure that K and L haven't been declared elsewhere?
I get a compile error on line 10:

S0231.png

[Don Wells]

Thank you Hans
    I was certain that I had thoroughly checked for the variable being declared elsewhere, so tried a reboot. While waiting for the machine the penny dropped. Remember this?

I have a module which I use solely as a temporary cache (Temp_Cache) containing 26 variant variables, A through Z.

    

[HansV]