How to debug code with the immediate window

[embekay]

Hello fellow Excel friends,

A co-worker of mine was helping me out with a piece of code and used the immediate window to quickly print out properties and evaluations of expressions without needing to use a msgbox. I am trying to figure out how to do just that.

From what I know, all you are suppose to do is lead what ever you want printed out with a '?', yet when I do this I keep getting the following compile error: method not valid without suitable object.

What am I doing wrong? Could you also provide a workable example so that I can test it out on my end and make sure it's just a syntax error.

Thanks.

 

[John_w]

Try this code in a new workbook. It puts numbers 1-10 in A1:A10 and loops through each cell. Step through the code using F8 and the comments show examples of what you can type into the Immediate window.

Sub Test()

    Dim r As Range, c As Range
    
    Set r = Range("A1:A10")
    r.Value = Application.Transpose(Array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10))
    ' ?r.address
    ' ?r.parent.name
    For Each c In r
        ' ?c.address,c.value
    Next
    
End Sub

 

[Smitty]

Welcome to the Board!

Another way to use the Immediate window is to use Debug.Print. E.G.

Debug.Print "whatever you would have put in a message box previously..."

Or in the case of John's example:

Debug.Print r.address
Debug.Print r.parent.name

HTH,

 

[embekay]

The "?" resulted in the same error as before, but the debug.print worked for me. Thanks for the replies.

 

[Norie]

The code would actually need to be running, but 'paused' if you are referring to objects within the code.