Hi guys!
I am trying to write a macro and I want to copy a cell from another workbook. The problem is that i want this workbook to be changeable. For example, I want to run the Macro with a cell from workbook 1, then I want to run the same macro with the same cell from workbook 2, and so on.
I thought of copying the macro and just change the workbook, but I have over a 1000 workbooks.
Can anybody help me? I am using the following code
Range("C2").Select
ActiveCell.FormulaR1C1 = "='[workbook1]Sheet1'!R9C2"
Thanks
I am trying to write a macro and I want to copy a cell from another workbook. The problem is that i want this workbook to be changeable. For example, I want to run the Macro with a cell from workbook 1, then I want to run the same macro with the same cell from workbook 2, and so on.
I thought of copying the macro and just change the workbook, but I have over a 1000 workbooks.
Can anybody help me? I am using the following code
Range("C2").Select
ActiveCell.FormulaR1C1 = "='[workbook1]Sheet1'!R9C2"
Thanks