Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
for i = 10 to 1 step -1
if application.CountA(cells(i,1).EntireRow) = 0 then cells(i,1).EntireRow.Delete end if Next -- Regards, Tom Ogilvy "Cor Steeghs" wrote in message ... I would appreciate any of your help in the following: How can it be detected whether all cells in a row are completely empty? In this case I want to delete empty rows. Thanks very much for your attention and/or reply and best regards, Cor Steeghs |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
need to detect syntax in value | Excel Discussion (Misc queries) | |||
I am completely fed up!! | Charts and Charting in Excel | |||
vlookup almost does this but not completely... | Excel Worksheet Functions | |||
Completely Stumped | Excel Discussion (Misc queries) | |||
Completely Locked Out | Excel Discussion (Misc queries) |