LinkBack URL
About LinkBacks
Hi.
I'm trying to print every 44 lines (including blank lines) per page.
Thank you!!!
Sub TryPrint() ' I need print 44 rows per page For i = 1 To 19766 Step 44 ActiveSheet.HPageBreaks.Add Before:=Cells(i + 1, 1) Next End Sub
Hi.
I'm trying to print every 44 lines (including blank lines) per page.
Thank you!!!Sub TryPrint() ' I need print 44 rows per page For i = 1 To 19766 Step 44 ActiveSheet.HPageBreaks.Add Before:=Cells(i + 1, 1) Next End Sub
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks