I have recorded a macro in Excel, however when I try to re-run the macro I get errors. Here is the code:
Workbooks(3).Activate
Sheets("Commentary").Select
Application.GoTo Reference:="R35C3"
Selection.Copy
Workbooks(2).Activate
ActiveWindow.SmallScroll down:=5
ActiveCell.PasteSpecial xlPasteValues
Workbooks(3).Activate
Application.CutCopyMode = True
ActiveSheet.Unprotect
ActiveSheet.Shapes("Group 28").Select
Selection.ShapeRange.Ungroup
ActiveSheet.Shapes("lblInventory").Select
Selection.Verb Verb:=xlOpen
Workbooks(2).Activate
ActiveWindow.SmallScroll down:=5
ActiveCell.Select
ActiveCell.PasteSpecial xlPasteAll
The macro always stops at the last line of code shown above. Is there something wrong with the code?
What I am attempting to do is run a macro to copy text from a textbox in one file to a cell in another file. I have tried various combinations of properties and methods but nothing seems to work. Anyone have any suggestions? Thanks!
Workbooks(3).Activate
Sheets("Commentary").Select
Application.GoTo Reference:="R35C3"
Selection.Copy
Workbooks(2).Activate
ActiveWindow.SmallScroll down:=5
ActiveCell.PasteSpecial xlPasteValues
Workbooks(3).Activate
Application.CutCopyMode = True
ActiveSheet.Unprotect
ActiveSheet.Shapes("Group 28").Select
Selection.ShapeRange.Ungroup
ActiveSheet.Shapes("lblInventory").Select
Selection.Verb Verb:=xlOpen
Workbooks(2).Activate
ActiveWindow.SmallScroll down:=5
ActiveCell.Select
ActiveCell.PasteSpecial xlPasteAll
The macro always stops at the last line of code shown above. Is there something wrong with the code?
What I am attempting to do is run a macro to copy text from a textbox in one file to a cell in another file. I have tried various combinations of properties and methods but nothing seems to work. Anyone have any suggestions? Thanks!