This isn't a variable problem it's a VBA problem.

There are times when no matter what VARIABLE (Int, String etc.) I hold my
cursor over while in debug mode it will not show me the value. Take the code
below for example if I put my cursor over "MyName" while stepping through
the code Sometimes it will show the value and sometimes it won't show
anything. Even shutting down Excel and reloading it doesn't seem to restart
this.



Dim MyName as String

MyName = "What Ever"

Debug.Print MyName