Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Office Software > print 1 excel row per page

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

print 1 excel row per page

Reply to Message Icon

Name: remdog99
Date: January 22, 2004 at 12:04:59 Pacific
OS: windows 2000/office 2003
CPU/Ram: P3/288
Comment:

Is there an e-z way to print 1 row in an excel sheet per page using just 1 print command?



Sponsored Link
Ads by Google

Response Number 1
Name: dtech10
Date: January 23, 2004 at 07:15:25 Pacific
Reply:

Don't know about an e-z way, but you could write a macro to do this.

Sub Macro1()
Rem Print three lines Range("A1:A9) on seperate sheets
Dim x As Integer

For x = 1 To 3
Worksheets("Sheet1").Range(Cells(x, 1), Cells (x, 9)).Select
Selection.PrintOut Copies:=1, Collate:=True
Next x
End Sub


0
Reply to Message Icon

Related Posts

See More



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links
Ads by Google


Results for: print 1 excel row per page
Printing 2 Handouts per page www.computing.net/answers/office/printing-2-handouts-per-page/5654.html

Excel row height problem using sort www.computing.net/answers/office/excel-row-height-problem-using-sort/6022.html

cannot print in excel www.computing.net/answers/office/cannot-print-in-excel/429.html