| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change a field and delete row
Hi Guys,
I would like to delete the row if a column "status" changes to "closed. this is what I got, but of course it is not working can you help? Dim cnclrge As Range ' If ActiveCell.Offset(0, 17) = "Closed" Then ' ' cnclrge.EntireRow.Delete ' End If Thanks Albert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete calculated field | Excel Discussion (Misc queries) | |||
| Unable to change field settings in calculated field in a pivot tab | Excel Discussion (Misc queries) | |||
| How do I use a keyboard to change a PivotTable or delete a field? | Excel Discussion (Misc queries) | |||
| How do I use a keyboard to change a PivotTable or delete a field? | Excel Discussion (Misc queries) | |||
| If field in column is blank, delete if.... | Excel Programming | |||
Threaded Mode
