32CARDS
Board Regular
- Joined
- Jan 1, 2005
- Messages
- 123
I am not sure if this is the correct method, but to avoid copy and paste of cell values from one workbook to another.
WorkBook1 opens Workbook2,
( Workbook2 has Functions etc, but requires data from Workbook1, it does the functions/calculations etc, then I Save and Close Workbook2)
The location of the cell ranges, for simplicity are the same.
So in Workbook1 Sheet1 Cell Range C7 to C19 Values,
require to go to
Workbook2 Sheet1 Cell Range C7 to C19
How would I do this from one Workbook to another without the macro doing a Copy and PasteValues method ?
Thanks
WorkBook1 opens Workbook2,
( Workbook2 has Functions etc, but requires data from Workbook1, it does the functions/calculations etc, then I Save and Close Workbook2)
The location of the cell ranges, for simplicity are the same.
So in Workbook1 Sheet1 Cell Range C7 to C19 Values,
require to go to
Workbook2 Sheet1 Cell Range C7 to C19
How would I do this from one Workbook to another without the macro doing a Copy and PasteValues method ?
Thanks