How can I show only rows that have data in excell 2003?

G

Gary''s Student

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excell table 1
Inserting blank rows in Excell 6
Using Regular expressions in Excell 2007 1
Few rows on my excell sheet have shifted down. How can I restore? 2
Excell 2003 / 2007 6
Display No Data in Pivot 1
Reseting the Standard colors in excell 2007 1
Set Excell 2007 to open new from G drive 2

Top