How to use a range variable as a function argument

[KS_user]

I'm trying to make the "EDS_Value" formula act on each cell in the range MasterTag (the cell in the column next to it is also an argument). However, I keep getting an "application- or object- defined error." I'm almost positive it's something to do with the syntax of how I'm entering 'cell' into the formula argument, but I've tried everything and I can't get it to work. Help! Thanks!

Sub MasterTagList()

Dim MasterTag As Range
Dim Cell As Range

For Each Cell In Range("MasterTag")
Cells(i, 6).FormulaR1C1 = "=EDS_Value(" & Cell & ", RC[-1])"
i = i + 1

Next Cell
End Sub

 

[shg]

Is "Master Tag" the name of a range on a worksheet?

Variable i is not initialized (or declared) so its initial value is 0; there is no row 0.

You have a For loop that doesn't use the loop variable (Cell)

What is the code supposed to do?