How can I show only rows that have data in excell 2003?
How can I show only rows that have data in excell 2003?
|
How can I show only rows that have data in excell 2003?
Use Data Auto-Filter to show only "Non-Blanks"
-- Please remember to indicate when the post is answered so others can benefit from it later. "myqs" wrote: How can I show only rows that have data in excell 2003? |
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? |
All times are GMT +1. The time now is 07:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com