Printing only Rows with a value in a specific column

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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

Excel Help to copy information from one row at a time to another sheet 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Variable print area via a macro 9
Having Blank Cells, etc. ? 1
Want to print only rows that have value in certain columns- Excel 2
organizing rows and columns by text 1
Printing only rows with value in certain column 4
wrap columns to print in rows 1

Back
Top