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
Code: Select all
Option Explicit
Public Sub kkk()
10 K = ThisWorkbook.Path
20 L = K
30 LA = ThisWorkbook.Path
End Sub
I have a module which I use solely as a temporary cache (Temp_Cache) containing 26 variant variables, A through Z.