Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hello I have this code to delete rows blank in columns at my choice but I need also include another choice "delete all rows if rows in X column are blank OR have a certain word (also at my choice " Is it possible ??? Thank you cc Sub DeleteEmptyRowsMain() Dim myColm As Range Dim LastCell As Range Set myColm = Application.InputBox("Choose Start of column to clear", Type:=8) Set LastCell = Cells.Find("*", , , , , xlPrevious) On Error Resume Next If Not myColm Is Nothing Then Range(myColm, Cells(LastCell.Row, myColm.Column)).SpecialCells(xlCellTypeBlanks).Ent ireRow.Delete Else MsgBox "No Range Selected", vbOKOnly, "Error" End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
delete the test values, but do not delete the formulas | Excel Discussion (Misc queries) | |||
How can I delete a macro when the Delete button is not active? | Excel Worksheet Functions | |||
How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions |