Count Formula

[dracron]

I have a mail merge type thing going on where I pull over data and print and then it moves to the next in excel.
how I do this is by setting a first set record and a last set record.

It prints 10 to a page and then pulls the next 10 so on and so on
Lets say I have **45 records (this number is in cell A2 by a counta formula) I know that 5 pages will print, the first set of records (always) starts at 2 and then the last of set of records start at 42.
these are cell numbers, usually

What I want to do is have a formula that tells me where the last set of records will be based on the fact it always starts at 2 and has 10 records to a page.

Clear as mud?

 

[RickXL]

Hi.

You mean something like this:

Sub Calculate_Last_Start_Row()

    Dim Start_Row As Long, N_per_Page As Long, N_Total As Long, Last_Start As Long
    
    Start_Row = 2
    N_per_Page = 10
    N_Total = 45
    
    Last_Start = Int(N_Total / N_per_Page) * N_per_Page + Start_Row

End Sub