Copy & paste in another workbook

  • I am having the hardest time with copying and pasting which shouldn't be so difficult. This code is only pasting the # of used cells in the range when it should be copying whatever values are in that range"D4:D43". Also, this is a dynamic range meaning that not all rows will contain data and therefore not all rows will need to be copied each time. Can anyone tell me where I am going wrong here?