| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete contents of cells in a range based on value of a cell
I want to be able to delete the contents of a range of cells
(A100:K200) based on the values I manually enter into cells A1 and B1, everything to run in Sheet1. A1's entry is the first row of the range to delete (A100:K100) and B1's entry is the last row of the range (A200:K200). Can someone provide a fairly simple macro for this? Thanks in advance. Michael |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete ROW based on Cell Contents | Excel Discussion (Misc queries) | |||
| Delete row based on contents of cell | Excel Discussion (Misc queries) | |||
| Delete Row based on cell contents | Excel Programming | |||
| Delete/clear a cell based on another cells contents | Excel Programming | |||
| How do I select a whole range and delete the contents of the cells? | Excel Programming | |||
Threaded Mode
