#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 553
Default Break Mode

While executing the following code I am getting a message
"CANT EXECUTIVE CODE IN A BREAK MODE"

Sub FARAZCUT()
On Error GoTo ErrorHandler
Range("A4").End(xlDown).Select
ActiveCell.Offset(1, 0).Activate
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Exit Sub ' Exit to avoid handler.
ErrorHandler:
MsgBox "Copy Something First!"
End Sub

What might be the reason?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 417
Default Break Mode

You mean:
"Can't execute code in break mode"

This is correct. While you have a breakpoint set and you are
single-stepping through that code, you cannot run another macro.

You need to finish single-stepping through the code where the breakpoint
is, then set a new breakpoint somewhere else and start debugging that code.

--
Regards,
Bill Renaud



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Break Mode Lost and Looking for Help Excel Programming 3 June 1st 06 08:21 PM
Can't enter break mode eugene Excel Programming 0 May 11th 06 09:21 PM
opening in break mode? Eric[_27_] Excel Programming 0 February 23rd 05 05:59 AM
Break mode not working Matt Excel Programming 0 July 29th 04 09:01 PM
Break Mode query Ron McCormick[_2_] Excel Programming 0 January 15th 04 02:19 PM


All times are GMT +1. The time now is 09:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"