Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Assuming your cells in Column C have data in them so that your ="" condition
means an empty cell, and not formulas that evaluate to "", then give this "non looping" macro a try... Sub DeleteEmptyCellsColumnC() On Error Resume Next Range("C10:C" & Cells(Rows.Count, "C").End(xlUp).Row). _ SpecialCells(xlCellTypeBlanks).EntireRow.Delete End Sub -- Rick (MVP - Excel) "LiAD" wrote in message ... Hi, Could some give me a code please to delete the entrie row if any cell in col C of that row starting from c10 going to the last cell down = ""? Thanks LiAD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete code after use | Excel Programming | |||
How to Delete VBS code via VBA | Excel Programming | |||
Code to delete a Line in a another code | Excel Programming | |||
VBA code delete code but ask for password and unlock VBA protection | Excel Programming | |||
VBA code to delete VBA code in another Workbook | Excel Programming |