Hi Carole,
I don't know of any built-in capability to highlight empty rows, so here is a macro that will do this:
Sub HiliteEmptyRows()
'Highlights empty rows in active worksheet in yellow
Dim Row As Range
For Each Row In Range(Rows(1), Rows(ActiveSheet.UsedRange.Rows(1).Row + _
ActiveSheet.UsedRange.Rows.Count - 1))
If IsEmpty(Cells(Row.Row, 1)) Then
With Cells(Row.Row, 1).End(xlToRight)
If .Column = 256 And IsEmpty(.Value) Then
Row.Interior.ColorIndex = 6
End If
End With
End If
Next Row
End Sub
If you would rather the macro just select the empty rows to highlight them, then use this macro instead:
Sub SelectEmptyRows()
'Selects empty rows on active worksheet
Dim Row As Range
Dim EmptyRows As Range
For Each Row In Range(Rows(1), Rows(ActiveSheet.UsedRange.Rows(1).Row + _
ActiveSheet.UsedRange.Rows.Count - 1))
If IsEmpty(Cells(Row.Row, 1)) Then
With Cells(Row.Row, 1).End(xlToRight)
If .Column = 256 And IsEmpty(.Value) Then
If EmptyRows Is Nothing Then
Set EmptyRows = Row
Else
Set EmptyRows = Union(EmptyRows, Row)
End If
End If
End With
End If
Next Row
If Not EmptyRows Is Nothing Then EmptyRows.Select
End Sub
To install these macros in your workbook, just use Alt-TMV and paste the code into the VBE code pane that appears. To run either of them use Alt-TMM, select the desired macro, and click Run.