detect empty rows or columns

[guest]

is there any quick way to detect all empty rows and columns in the selected
data without reading all cell values?? quick help would be appreaciated.

thanks.

 

[Susan]

AFAIK there's no way without looping through the cells and checking
them.
sorry!
susan

 

[Gord Dibben]

Sub Color_Blanks()
Dim rng As Range
Set rng = Nothing
On Error Resume Next
Set rng = Selection.SpecialCells(xlCellTypeBlanks)
On Error GoTo 0
If rng Is Nothing Then
'do nothing
Else
rng.Interior.Color = vbYellow
End If
End Sub


Gord Dibben MS Excel MVP

 

[David McRitchie]

A cell with a formula in it would not be empty
Delete ALL rows that are Entirely Blank (#RemoveEmptyRows)
http://www.mvps.org/dmcritchie/excel/delempty.htm#RemoveEmptyRows

 

[David McRitchie]

Sorry misread as delete, ignore my reply. Gord had it right.