Call Same Cell in Athr Wks during Loop

Hi,

I am running a loop through a range in one worksheet but need to copy a cell from a different worksheet. Therefore I cannot just call up the other worksheet and copy the cell because it changes in the loop and I don't want it hardcoded. Is there a way to copy the cell row and column from the loop I am running on one worksheet and then use it in the second worksheet. Something like the following:

Dim R As Range
Dim C As Range
For Each RngCell In DataRange
    For i = 1 To ActiveRange
    RngCell.Activate
    Set R = ActiveCell.Row
    Set C = ActiveCell.Column
    Wks"DPML".Activate
    Set DPMLCell = Range("R:C")