Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print Selectd Rows
I am trying to print out an excel sheet where only rows with column J not
equal to zero print. I used the following code found on a linked website. When I print, I still get all 500 rows. Any idea why this code does not work? Thanks Sub Hide_Print_Unhide() Dim rw As Long Application.ScreenUpdating = False With Sheets("Quotations") For rw = 1 To 500 If Application.WorksheetFunction.CountJ( _ .Cells(rw, 1).Range("J1")) = 0 Then _ .Rows(rw).Hidden = True Next rw .PrintOut ' for testing use .PrintPreview .Range("J1").EntireRow.Hidden = False End With Application.ScreenUpdating = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print has some blank rows but screen has data in rows | Excel Discussion (Misc queries) | |||
how to print the rows more than 62000 rows | Excel Worksheet Functions | |||
Sort - selectd rows ?? | Excel Discussion (Misc queries) | |||
Print few rows with many colums so that rows wrap on printed pages | Excel Discussion (Misc queries) | |||
deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions |