How to refer to a cell from another workbook in VBA
Workbooks("Material").Worksheets("StoreA").Range(" A1")
etc.
Regards,
Stefi
€˛diepvic€¯ ezt Ć*rta:
Hi,
I want to check the date in 5 cells belongings to 5 different worksheets of
5 workbooks to make sure they are all the same.
E.g: Cell A1 in worksheet "StoreA" of workbook "Material"
Cell A1 in worksheet "StoreB" of workbook "Tools"
Cell A1 in worksheet "StoreC" of workbook "WIP"
Cell A1 in worksheet "StoreD" of workbook "Goods"
Pls advise me a VBA code to solve this.
Thanks so much
|