"Can't Enter Break Mode"?
The following code is supposed to copy a text box and then paste it in
another sheet. Sub Macro9() Sheets("Prod. Res.").Select ActiveSheet.Shapes("ScrollingTextBox").Select Selection.Copy Sheets("Summ").Select Range("A152").Select ActiveSheet.Paste Range("B159").Select End Sub This code was made using the record macro function. However, after recording, it won't run it. When stepping through it, excel says, "Can't enter break mode at this time." when it tries to do the "ActiveSheet.Paste" step. (It actually does paste it, but then faults.) Anybody have any ideas? Thank you! |
"Can't Enter Break Mode"?
I've found that when that happens, that I can run the macro (not step) and it
works fine. Or I set a break point before the offending line and after the offending line and run that offending line without stepping through it. CWillis wrote: The following code is supposed to copy a text box and then paste it in another sheet. Sub Macro9() Sheets("Prod. Res.").Select ActiveSheet.Shapes("ScrollingTextBox").Select Selection.Copy Sheets("Summ").Select Range("A152").Select ActiveSheet.Paste Range("B159").Select End Sub This code was made using the record macro function. However, after recording, it won't run it. When stepping through it, excel says, "Can't enter break mode at this time." when it tries to do the "ActiveSheet.Paste" step. (It actually does paste it, but then faults.) Anybody have any ideas? Thank you! -- Dave Peterson |
"Can't Enter Break Mode"?
Thanks Dave. I could have sworn it didn't work and I that is why I was
stepping through it. Oh well, it works now. "Dave Peterson" wrote: I've found that when that happens, that I can run the macro (not step) and it works fine. Or I set a break point before the offending line and after the offending line and run that offending line without stepping through it. CWillis wrote: The following code is supposed to copy a text box and then paste it in another sheet. Sub Macro9() Sheets("Prod. Res.").Select ActiveSheet.Shapes("ScrollingTextBox").Select Selection.Copy Sheets("Summ").Select Range("A152").Select ActiveSheet.Paste Range("B159").Select End Sub This code was made using the record macro function. However, after recording, it won't run it. When stepping through it, excel says, "Can't enter break mode at this time." when it tries to do the "ActiveSheet.Paste" step. (It actually does paste it, but then faults.) Anybody have any ideas? Thank you! -- Dave Peterson |
All times are GMT +1. The time now is 06:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com