| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional row delete using macr
The macro below deletes alternate rows instead of all rows with Zero. I do not
know VBA. What is wrong. Application.Goto Reference:="col" For Each cell_in_loop In Range("col") If cell_in_loop.Value=0 Then With cell_in_loop.EntireRow.Delete End With End If Next ActiveWorkbook.SaveAs Filename:=C\Data\Sales............. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display "Last updated date" for the Workbook (without using a macr | Excel Worksheet Functions | |||
| how to move data from a cell to another one without using any macr | Excel Worksheet Functions | |||
| Copy data from one worksheet to another using a function or a macr | Excel Worksheet Functions | |||
| How do I convince the cursor to select a given cell when in a macr | Excel Discussion (Misc queries) | |||
| Insert row with macr | Excel Programming | |||
Threaded Mode
