| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change a field and delete row
Thanks guys, sorted.
"FSt1" wrote: hi your not setting the active cell to equal cnclrge. Dim cnclrge As Range set cnclrge = activecell If ActiveCell.Offset(0, 17) = "Closed" Then cnclrge.EntireRow.Delete 'or Activecell.EntireEow.Delete end if Personally i dislike using Activecell and perfer using variables but everyone has your own way. Regards FSt1 "Albert" wrote: 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
