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.