Mar 21 2022 06:59 AM
Mar 21 2022 07:14 AM
You don't need the .Value:
ActiveWorkbook.Worksheets("Page One").Range("C3").Copy _
ThisWorkbook.Worksheets("Pull").Range("C11")
Mar 21 2022 07:40 AM
Mar 21 2022 10:04 AM
How about
ThisWorkbook.Worksheets("Pull").Range("C11").Value = ActiveWorkbook.Worksheets("Page One").Range("C3").Value
Mar 22 2022 03:21 AM
Mar 22 2022 05:36 AM
Which workbooks are open when you run the code?
Which one of them is the active workbook?
It might help if you posted more of the macro.
Mar 22 2022 06:25 AM
Mar 22 2022 06:26 AM
Mar 22 2022 06:38 AM
So the Email Tool workbook should contain a worksheet named Pull.
The contract workbook should also be open in Excel. It should be the active workbook when you run the macro, and it should contain a worksheet named Page One.
If the name of the sheet might vary, but if you are sure that it will always be the first worksheet in the contract workbook, you might use
ThisWorkbook.Worksheets("Pull").Range("C11").Value = ActiveWorkbook.Worksheets(1).Range("C3").Value