is it possible to make it so that range("D3")(from workbook1)=range("D4").value(from workbook2) without opening workbook 2?
i will be working on workbook 1 and on the click of a command button will want some range from workbook2 but will not want this workbook open, it has been possible to open this workbook selcet range("D4") copy activate workbook 1 select range("D4") and paste but this is inefficient as there are 150 cells that need to be transferred
if there is a more efficient code please help
Bookmarks