I am running a macro that starts in Excel goes to Word and returns to excel. And it won't paste what is in the clipboard. Any suggestions????As to why I get the following runtime error 1004??? I click on the debugger and the following line is highlighted
ActiveSheet.PasteSpecial Format:="Text"
AppActivate "Microsoft Excel"
Columns("A:A").Select
Range("A1").Select
ActiveSheet.PasteSpecial Format:="Text"
Range("A1").Activate
Oh, I am not an expert on code, please help. Thanks
ActiveSheet.PasteSpecial Format:="Text"
AppActivate "Microsoft Excel"
Columns("A:A").Select
Range("A1").Select
ActiveSheet.PasteSpecial Format:="Text"
Range("A1").Activate
Oh, I am not an expert on code, please help. Thanks