I use a separate spreadsheet to store variables I want to keep after
breaking the program. Anyway, I don't think I've ever run into this
problem. If I use this code

Dim myGlobal as string

Sub Huhoh
myGlobal="still here"
msgbox 0/0
End Sub

myGlobal still keeps its string in Debug.

James