Hi All
I want to transfer data from one workbook to another picking out certain cells. I am trying to avoid the old copy and paste functions and just use something like this:
Workbook1.sheet1.Range("C32") = Workbook2.sheet1.Range("B52")
But I cannot get anything to work.
Can anyone help?
All help and advise is greatly appreciated!
Thanks
Tim
I want to transfer data from one workbook to another picking out certain cells. I am trying to avoid the old copy and paste functions and just use something like this:
Workbook1.sheet1.Range("C32") = Workbook2.sheet1.Range("B52")
But I cannot get anything to work.
Can anyone help?
All help and advise is greatly appreciated!
Thanks
Tim