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

  • Thread starter Thread starter myqs
  • Start date Start date
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
 
You must log in or register to reply here.

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

I can only delete an entire row not a cell in excel 2013? 1
How can I insert rows BELOW, in Excel 1
Save as CSV not saving the same from Excel 2007 then in Excel 2003 1
Show only rows with duplicate values in a column? 4
Does table have at least one row in Excel 2007? 4
I have more than 65K rows when I open Excel 2007 2
Excel 2007 showing empty rows at bottom 1
How To Have A Cell Be Blank If... 2

Back
Top