| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete rows
Hi,
Try this but note empty cells are treated as numeric. Post back and tell us what should happen to empty cells If Not (IsNumeric(Cells(ActiveCell.Row, 1))) Then ActiveCell.EntireRow.Delete End If Mike "nc" wrote: Sub test() Selection.Rows.EntireRow.Delete End Sub Can you help ammend the above code to stop the row (selection) being deleted if the cell in column A has a number. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Delete empty rows in excel in b/w rows with values | Excel Worksheet Functions | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| Q: delete rows | Excel Discussion (Misc queries) | |||
| How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
| delete empty rows between rows with text | Excel Discussion (Misc queries) | |||
Threaded Mode
