cannot view workbook information in locals window

[kylefoley76]

I put in the code:

Dim wb As Workbook, str1 As String
Set wb = ActiveWorkbook

And when I look at the info for wb in the locals window for wb it just as no variables. I'm pretty sure that it was working a second ago.

 

[steve the fish]

You will be able to see wb in the locals window once the variable has been set and End Sub has not yet been reached.

 

[Yongle]

If you use {F8} to step through above code, you should see this by when you get to End Sub