| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can i auto hide empty rows in printing in excel?
Private Sub Workbook_BeforePrint(Cancel As Boolean)
LastRow = ActiveSheet.UsedRange.Row - 1 + _ ActiveSheet.UsedRange.Rows.Count Application.ScreenUpdating = False For r = LastRow To 1 Step -1 If Application.CountA(Rows(r)) = 0 Then Rows(r).EntireRow.Hidden = True End If Next r End Sub Gord Dibben MS Excel MVP On Fri, 1 Aug 2008 02:25:00 -0700, TM wrote: How can I auto hide empty rows in printing a table in excel? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide empty rows in pivot table Excel 2003 | Excel Discussion (Misc queries) | |||
| Is there a way to automatically hide empty rows? | Excel Worksheet Functions | |||
| Hide Empty Rows When Printing | Excel Worksheet Functions | |||
| Want to auto hide rows in excel when no data in a certain column. | Excel Discussion (Misc queries) | |||
| Format to hide empty rows | Excel Discussion (Misc queries) | |||
Threaded Mode
