How can I show only rows that have data in excell 2003?
Running this little macro will hide all the rows with no content:
Sub servient()
Dim nLastRow As Long
Set r = ActiveSheet.UsedRange
nLastRow = r.Rows.Count + r.Row - 1
Range("A" & nLastRow + 1 & ":A" & Rows.Count).EntireRow.Hidden = True
For i = 1 To nLastRow
If Application.WorksheetFunction.CountA(Rows(i)) = 0 Then
Rows(i).Hidden = True
Else
Rows(i).Hidden = False
End If
Next
End Sub
--
Gary''s Student - gsnu200814
"myqs" wrote:
How can I show only rows that have data in excell 2003?
|