worksheet row to print on two or more printout lines

rh62 · #1 06-12-2017, 01:56 PM

I want to print two or more lines per worksheet row with a blank print line separating snaking rows. I have a 50 column job cost report that will not fit well on one print line regardless of formatting. I want a printout like I get with other accounting applications. Experienced user.

Logit · #2 06-18-2017, 12:55 PM

.
You can use this macro to insert a blank row between existing rows of data on your worksheet:

Code:

Option Explicit

Sub Insert_Blank_Rows()
     
     'Select last row in worksheet.
    Selection.End(xlDown).Select
     
    Do Until ActiveCell.Row = 1
         'Insert blank row.
        ActiveCell.EntireRow.Insert shift:=xlUp
         'Move up one row.
        ActiveCell.Offset(-1, 0).Select
    Loop
     
End Sub

Before running the macro, click on the next to the last row of existing data. In other words, if you data on the sheet goes from A1 to A10, click on A9, then run the macro.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help! Why do straight lines have a sawtooth edge when I insert an image and print from Powerpoint?	SnowPatrol161	PowerPoint	1	02-06-2017 09:01 AM
Lines separate paragraphs in Print Layout view	FKerr	Word	5	08-13-2015 11:45 AM
Word 2010 Printing Lines NOT Showing on Print Preview	kziemke	Word	4	06-02-2015 07:16 AM
printer can't print out the lines	pclum	Word	4	07-02-2011 02:36 AM
Unable to print blank lines on a legal form	dpenbag	Word	0	03-20-2006 09:13 PM