A really, really strange Excel problem

[Zvoni]

Zvoni,

Thanks. Now I understand what is happening. I retested it on my computers, and it does not matter what you set strCol to, "AJ" or "XX", it shows as "" in the ToolTip if you put the break point on that line. If you put the break point on the End Sub, it works OK. You cannot put a break point on the commented out MsgBox, but you can if it is not commented. I usually avoid this issue by inserting Stop statements into the code where I want to check something.

Funny enough, in VBA i use a lot of „old school“ variable checking issuing Debug.Print‘s
i take it out of production code with a global const.
something along the lines

Public Const DO_DEBUG As Boolean = True


‘Somewhere else
If DO_DEBUG Then Debug.Print SomeVariable

When the code goes live i just set the constant to False