Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Code | Excel Discussion (Misc queries) | |||
enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
Cell Selection after "Enter" | Excel Discussion (Misc queries) | |||
Can't delete a page break | Excel Discussion (Misc queries) | |||
Is there way to enter multiple values into excel cells w/ a form? | Excel Discussion (Misc queries) |