Hello,

It's been awhile but have always found a guru on here!!! Many blessings to our excel gurus!!!

I need this vba to simply keep the cell reference of the row being iterated.

Right now it only pastes the non-relative formula for each cell containing "IAD". So, as it goes down I need the RELATIVE formula to paste. You know... like if you type a formula then drag it down a column? But, I do not want that because some cells need to be blank for other cities.

You will notice that when the test fails the cell is left blank... this was on purpose because these cells will be used for other cities in the same manner so I do not want to write over previous entries.

Sub Tryinsohard()

Dim sht As Worksheet
Dim i As Long
Dim lastrow As Long

Set sht = ActiveSheet

For i = 2 To Rows.Count
    
        If sht.Cells(i, 4).Value = "IAD" Then
           sht.Cells(i, 4).Offset(0, 2).Formula = " FORMULA HERE "
        Else
        
        End If
        
i = i + 1

Next i

End Sub
Help please???

Dan