If I wanted/hoped to have a screenshot of the exact error (specifically the highlighted line) of code and to save it in a file on my desktop. I am not exactly sure how to do this and was hoping I could get some help. Thanks!
I know of no way to do that, the closest is to use line numbers & report that like
Dim Rng As Range
10 On Error GoTo myerr
20 Set Rng = Sheets(1).Range("A2", Range("A" & Rows.Count).ende(xlUp))
30 Exit Sub
40 MsgBox "Error " & Err.Number & vbLf & Err.Description & vbLf & "On line " & Erl