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?


  • Try changing


    Code
    Set rngND = shtND.Range("D4:D43" & Last).End(xlUp).Rows

    to


    Code
        Set rngND = shtND.Range("D4:D4" & Last).End(xlUp).Rows

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!