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

CAPT.PT · Mar 14th, 2002, 01:17 PM

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 · Mar 14th, 2002, 01:30 PM

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.

Mar 14th, 2002, 04:03 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 01:17 PM	#1
CAPT.PT New Member Join Date: Mar 2002 Posts: 32	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

Mar 14th, 2002, 01:30 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	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.

Mar 14th, 2002, 04:03 PM	#3
Guest Posts: n/a	Another way is to use Autofilter (non-blanks).