Error 9 in Excel Code

Copper Contributor

Hi

 

My version of Excel is 2016 (16.0.4266.1001). I had found a  Macro in VBA for cutting and pasting data from one workbook to another since I have not been trained in writing subs or Macros. When I  run this VBA code I am getting an error 9 in spite of the fact that I have checked and rechecked the Workbook names as well as the worksheet names for each Workbook.  Attached you will find a screenshot of the sub or Macro that I have used. If someone could please tell me why this is happening and what I can do. 

Code for Copying and Pasting.png

0 Replies