Macro Return value from specific column and active row.

[ropalmanhani]

Hi,

I am trying to run a macro to return the value from workbook1 to workbook2. All time a move the row on workbook1 the value is updated on workbook2.
The value to return on workbook1 are on column C.

Sub

Application. _
Value =
Workbooks("Book1.xlxs").Worksheets ("Sheet1").Cells(3, activecell,row)

End Sub

Thank you