Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Basically, I'm trying to delete the entire row in my worksheet if
Columns F-P are all blank. I have this macro written so far, but I'm can't seem to decipher what I'm missing to have it work. Thanks in advance for helping with my novice programming. Sub Gift() With .Cells(Lrow, "F") If Application.CountA(.Range(.Cells(Lrow, "F"), .Cells(Lrow, "P"))) = 0 Then .Rows(Lrow).Delete End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to count entries in one column based on critieria in another c | Excel Discussion (Misc queries) | |||
Deleting Rows based on Column Critieria | Excel Discussion (Misc queries) | |||
Deleting rows based on values in a column | Excel Programming | |||
Deleting rows based on values in a column | Excel Programming | |||
Deleting rows based upon the value in column D | Excel Programming |