Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
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) |