Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help
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","")) |