General form is:
Workbooks("Workbook1").Worksheets("Sheet1").Range( "ac2")=Workbooks("Workbook2").Worksheets("Sheet2") .Range("b2")
Substitute in your workbook names (exactly as they show in the Excel title
bar when the workbook is open, or in the Project Explorer list in the VBA
editor).
--
- K Dales


"Luc" wrote:

I would like to use the e.g.
Sheets("sheet1").Range("ac2") = Sheets("sheet2").Range("b2")
command (which works within a wookbook) but between 2 workbooks. How can I
impose a value of workbook1 to workbook2 in the assumption that wookbook2 is
open?