Printing Form for each record (multiple forms per page)

Hello all,

Please forgive my lack of knowledge, I am learning .

I have a macro that prints a Form or "ticket" for each record in my table. One ticket per page. It works great, however, I would like to print three tickets per page. I have no clue where to start. Can anyone offer any guidance? Please see current code below.

Sub PrintAll()
RowCount = Worksheets("BILL - Monthly GSB_18").Cells(Rows.Count, 1).End(xlUp).Row - 1
Worksheets("Macro").Select
For i = 1 To RowCount
Range("A1").Value = i
ActiveSheet.PrintOut Copies:=1
Next i
End Sub

Thanks in advance

what are your sheet names? are you going to print 3 tix per sheet for all worksheets? maybe upload a sample workbook so that i can see what is going on.

can you take a look at sheet Macro and fix formula for AC14, it is generating an error (#NAME?). fix that and tell me what the new formula is (i think the issue is you have a BOB but no range named that.)

Should be fixed. Sorry for delay

Yes both of those ranges are fixed.

Wow. This is great! I love the message box too. Thanks for teaching me something new, really appreciate it.

i realized that after printing there were errors in how it was printed. that and some ifNA statements, i got it going pretty good. if this is acceptable, mark the thread as solved and if you feel generous, you can click on the add reputation link, i would appreciate it.