| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete/clear a cell based on another cells contents
Could someone assist me with the following problem please.
I have a sheet that has about 1000 rows and about 50 columns. I would like to write a macro that will clear the cell contents of 4 cells in one row IE AC3,AD3,AE3 and BL3 based on whether the contents of cell BW3 = "Yes". The macro will the drop to the next cell IE BW4 and will clear the contents of the corresponding cells AC4,AD4,AE4 and BL4 if this has a "YES" in it. This will then continue until the bottom of the sheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I conditionally delete rows based on cell contents? | Excel Worksheet Functions | |||
| Delete ROW based on Cell Contents | Excel Discussion (Misc queries) | |||
| Clear Contents Of Cells Where Value = 0 | Excel Worksheet Functions | |||
| How do I add a cell based on another cells contents? | Excel Discussion (Misc queries) | |||
| Delete row based on contents of cell | Excel Discussion (Misc queries) | |||
Threaded Mode
