Printing only Rows with a value in a specific column

G

Guest

I have several rows of info but i would only like to print rows with a value
in a certain column. Any Ideas
 
R

Ron de Bruin

See this page for a macro solution
http://www.rondebruin.nl/print.htm

You can use this for example for column A in Sheet1
read the info on my site first

Private Sub Workbook_BeforePrint(Cancel As Boolean)
If ActiveSheet.Name = "Sheet1" Then
Cancel = True
Application.EnableEvents = False
Application.ScreenUpdating = False
With ActiveSheet
On Error Resume Next
.Columns("A").SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True
.PrintOut
.Columns("A").SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = False
On Error GoTo 0
End With
Application.EnableEvents = True
Application.ScreenUpdating = True
End If
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

Variable print area via a macro 9
Show only rows with duplicate values in a column? 4
Printing only rows with value in certain column 4
Want to print only rows that have value in certain columns- Excel 2
Using Macro to Hide Rows with Certain Values 2
hide rows if nil result of formula in specific column 2
Return value of non-blank cell 2
Hide / Unhide columns for Printing 1

Top