Cannot debug
Hi Emily,
'---------------
Is this normal (that you can't step through with variables in the Sub line),
or a weirdness in my Excel (2000 on WinNT)?
'---------------
As your macro has an argument (intFileID), you need to
call it from another procedure.
To step though your macro, try something like:
'=============
Public Sub Tester()
Call ChangeSource(intFileID:=5) '<<=== CHANGE
End Sub
'<<=============
---
Regards,
Norman
|