Gavin Harrison
New Member
- Joined
- May 2, 2017
- Messages
- 34
Hi All.
I'm struggling to find the code to clear the contents of cells based on the content of another cell in the same row. For example:
I have a range of A1:C700.
If on any of these given rows, if in column C of that row the cell contains "Depart", I would like to clear the contents of columns A & B in the same row.
This would happen multiple times in the above range.
Thanks in advance all.
I'm struggling to find the code to clear the contents of cells based on the content of another cell in the same row. For example:
I have a range of A1:C700.
If on any of these given rows, if in column C of that row the cell contains "Depart", I would like to clear the contents of columns A & B in the same row.
This would happen multiple times in the above range.
Thanks in advance all.