How do I disable anchors in my address?

[288enzo]

The below is adding anchors which is throwing me off when I sort.

An example of the final output is =IF(TODAY()-$N$822>10,"Expired",TODAY()-$N$822)
I need it to be =IF(TODAY()-N822>10,"Expired",TODAY()-N822)

    Dim LastRow As Long
    LastRow = Cells(Rows.Count, "V").End(xlUp).Row
        
    Dim i As Long
    
    For i = 2 To LastRow
    
    If Range("V" & i) = "" Then
    Range("V" & i) = "No"
    Range("W" & i) = "=IF(TODAY()-" & Range("N" & i).Address & ">10,""Expired"",TODAY()-" & Range("N" & i).Address & ")"
    End If
    
    If Range("V" & i) = "Yes" Then
    Range("W" & i) = ""
    End If
    
    Next

 

[Fluff]

You can use Range("N" & i).Address(0,0)

 

[288enzo]

You can use Range("N" & i).Address(0,0)

You're a lifesaver!

Thank you

 

[Fluff]

Glad to help & thanks for the feedback.