I posted last week in regards to this, however I do not think I was clear
enough in what I am looking for. I am trying to create a macro that looks a
cell and if that cell is has a "x"then I want the macro to clear the fields
to the left of that cell. I have
got it to work on a line by line basis but I wan to be able to set this macro
up to work on any line

If i7 = x Then Worksheets("Adjustment").Range("A7:h7").ClearConte nts

The code in the I column looks like this
=IF((H7=""),"",IF(TODAY()(30+H7),"X",""))