How can I print just what rows have info???

[CAPT.PT]

I have several worksheets that info sends to the last worksheet for payroll...certain rows from certain worksheets go into this last worksheet....how can I print just the rows that have information on them....is that possible???

Thank you, Capt. P

 

[Al Chara]

You can hide the blank rows and then print. Select the data and use the following code:

Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True

I hope this helps.
Kind regards, Al.

 

[Guest]

Another way is to use Autofilter (non-blanks).