![]() |
#1
|
|||
|
|||
![]() 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. |
#2
|
|||
|
|||
![]()
.
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 |
![]() |
|
![]() |
||||
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 |
![]() |
FKerr | Word | 5 | 08-13-2015 11:45 AM |
![]() |
kziemke | Word | 4 | 06-02-2015 07:16 AM |
![]() |
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 |