Clearing the contents of one cell, if another cell is blank

[AWardSand]

Hello All,

This is my first post here. I hope someone will be able to help.

I would like to be able to write a macro which will clear the contents of two cells (say L2 and M2), if another cell (say O2) is blank. If the other cell is not blank, I would like to leave the first cell as it is. I want to do this for every row in my spreadsheet (I have about 250 rows in my spreadsheet but that is not fixed).

I can think of what I would like to do in my head, but not what sort of macro would help me do it. As you may have guessed, I am very new to this. This is what I would like to achieve

Set a row count (i) to 2 (my data starts at row 2)
Loop while cell L(i) is not blank
If Cell O(i) is blank
Set cells L(i) and M(i) to blank
Else
Do nothing
add 1 to my row count
end loop

I hope this makes sense - I have attached a pic of the data which I hope will make it more clear

Many thanks
AlysExcel Problem.PNG

[rollis13]

This will somehow do what you have in mind. The macro, to be copied in the vba module of the sheet, will trigger every time you change something in that sheet since it checks the state of the event Worksheet_Change.

Please Login or Register  to view this content.

[AWardSand]

Thank you so much, this does exactly what I hoped it would. So helpful, I really appreciate your time.

Alys

[rollis13]

Glad having been of some help .