Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Blank Cells Subject to Criteria (Originally Posted in Excel by Mistake)
I wanted to delete blank rows using the following:
Public Sub DeleteRowOnCell( On Error Resume Nex Selection.SpecialCells(xlCellTypeBlanks).EntireRow .Delet ActiveSheet.UsedRang End Su But I wanted instead of to check for an empty cell (as the above does?) to see if the following formula returned "" and delete the row if it did and to leave it if it didnt =IF(ISERROR(VLOOKUP(B1,Sheet2!A1:A10,1,FALSE))=TRU E,"","1" If anyone can help i'd sure appreciate it Thanks in advanc Mar |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: Request to speed up deleting blank cells | Excel Discussion (Misc queries) | |||
Deleting spaces in blank cells | Excel Discussion (Misc queries) | |||
Deleting blank cells in a column | Excel Discussion (Misc queries) | |||
Deleting rows with blank cells | Excel Worksheet Functions | |||
Deleting blank cells in a selection | Excel Programming |