LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
CWillis
 
Posts: n/a
Default "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!
 
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
VBA Code Cell Mate Excel Discussion (Misc queries) 4 January 9th 06 08:52 PM
enter data on 1 sheet and make it enter on next avail row on 2nd s Nadia Excel Discussion (Misc queries) 27 September 9th 05 03:39 PM
Cell Selection after "Enter" Synectica Excel Discussion (Misc queries) 6 August 29th 05 09:55 PM
Can't delete a page break Suhail Excel Discussion (Misc queries) 4 July 7th 05 06:49 PM
Is there way to enter multiple values into excel cells w/ a form? grassfed Excel Discussion (Misc queries) 1 June 22nd 05 05:26 PM


All times are GMT +1. The time now is 05:44 PM.

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

About Us

"It's about Microsoft Excel"