| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete rows using VB
Hi,
I'm using a macro that delete rows that are blank. However, I want the macro to delete rows that are equal to zero. This is my program: Sheets("Group-rep").Select Range("B11:B142").Select Selection.SpecialCells(xlCellTypeBlanks).Select Selection.EntireRow.Delete Range("A1").Select what should I put on the SpecialCells? Is there a way in the help option to find out what I should use? Thanks Miguel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Rows if any cell in Column H is blank but do not Delete Fir | Excel Programming | |||
| Copy pasting Rows, but need to Delete any Shapes/Pictures that are within copied rows | Excel Programming | |||
| Delete rows with numeric values, leave rows with text | Excel Programming | |||
| How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
| Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming | |||
Threaded Mode
