Clear Contents in OffSet cell if value is below U1

[adamprocter]

If a value in I is great than a value in U1 then I want to clear contents in P on the same row
So I thought best way would be to use the offset value as I loop through the values...
but excel moans about

c.Offset(, 7).ClearContents

But

c.ClearContents

works great but clears I

Dim LastRow As Long
LastRow = Sheets("Dashboard").Cells(Cells.Rows.Count, "I").End(xlUp).Row

Set MyRange = Sheets("Dashboard").Range("I6:I" & LastRow)
For Each c In MyRange
If c.Value > Sheets("Dashboard").Range("U1") Then

'ClearContents of same row in P

c.Offset(, 7).ClearContents

End If
Next

 

[adamprocter]

sorry this works :D typo on another line !