Macro dbug

[Leo Kline]

I have written a macro and want to debug it step by step. I am familiar with
"stepping into" the macro but forget how to move thru it step by step.

 

[Peter Hewett]

Hi Leo Kline

The IDE has a Debug menu option have you checked that out? It supports:

Step Into (F8)
Step Over (Shift+F8)
Step Out (Ctrl+Shift+F8)
Run To Cursor (Ctrl+F8)

HTH + Cheers - Peter

 

[Jezebel]

F8. Also make use of Debug.Print and Debug.Assert, and F9 for breakpoints.

 

[Leo Kline]

Thanks! I thought that F8 was the correct key to use to step thru the code
but it injected a one line routine that I did not recognize. It was
;;Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
End Sub
so I thought I had selected the wrong key.