Debugging or program issue?

[erutherford]

My debugging features don't appear to be working.

Wrote some simple code just to work with.

Private Sub Worksheet_Change(ByVal Target As Range)

If Intersect(Target.Range("A1:A10")) Is Nothing Then

MsgBox "Nothing in here"

Else

MsgBox "something here"

End If

End Sub

Now the code gives a "argument not optional" error and the debug choices do not work!

any ideas?
2013 version

 

[mumps]

Try:

If Intersect(Target,Range("A1:A10")) Is Nothing Then

The period should be a comma.

 

[erutherford]

Oops. Code functions. When you put in a breakpoint, the code will run to the breakpoint and stop. Then you have to reset the code if you change the breakpoint?

What is required to run the "step into"?

Thanks mumps

 

[mumps]

Maybe you could play with a couple of other things. Have you tried pressing the F8 key? This will step through the macro one line at a time. Also, when you do this or put in a break point, you should see a yellow arrow in the left margin with the row highlighted in yellow. You can click and drag the yellow arrow up or down to a different line of code and continue stepping through using the F8 key or run the code to the next break point.