Compile Error "Only Comments .."

I have an Excel spreadsheet dfor which I have written a large number of interlinked subroutines in VBA. Recently (after some 10 years or so) I have received "Out of Memory 0" errors for which I split up the longest subroutine. Now I receive "Compile Error "Only Comments may appear after End Sub, End Function or End Property." This seems to appear following a SUB Name() statement. Looking at the available help, I suspected it should relate to the preceeding subroutine. Unfortunately, the preceeding subroutine is only 3 lines long: (SUB name(); Call Name2; End Sub). When I comment out the sub then the error message appears somewhere else. Help!!!

This thread is locked. You can vote as helpful, but you cannot reply or subscribe to this thread.

No results