View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Execution ends without error message in middle of program

Nothing obvious in the single line of code and your description. Do you have
user defined functions in the worksheet - if so, these can often be
problematic if not populated with good error handling code.

--
Regards,
Tom Ogilvy



"Richard J. Snee" wrote:

I have several macros that I can not debug. When I run them in the debugger
they go along just fine and then act as if they they just encountered an END
statement. That is execution ends without any error message or other
indication of failure. The code lines do not seem to have any errors. For
example:
Selection.EntireRow.Hidden = True
I get a valid selection in the immediate window ( ? selection.address --
$1:$100) just before executing this line but the macro just stops. Once when
I tried to add an On Error Goto x I got a can not enter break mode here
message. Now execution just terminates.

Any ideas/tips