Referencing A Cell In Excel

[SandraF]

I have the following code to assign the value of one cell to another (in a macro):


Worksheets("LOG&quot.Cells(Counter, 5).Value = ws.Cells(iRow, 1).Value

The problem is that I want to assign the cell reference to the Log worksheet cell so that if someone changes the contents of the cell in the ws worksheet it is linked to and will change the cell in the log worksheet automatically.

I have tried the address function in my macro, but can't get it to work.

Any Syggestions?

 

[dsi]

Let's assume that you want to reference cell "C3":

Worksheets("LOG").Cells(Counter, 5).Formula = "='" & ws.Name & "'!C3"

DimensionalSolutions@Core.com