Determine page which row will print on

F

Fred Smith

Is it possible in VBA to determine which page number a certain row will
print on?

I have a report which groups various rows, and I want to keep each group on
the same page. I envision a loop where I remember the page number for the
first row in the group, and compare it to the last row in the group. If the
page numbers are different, I want to programmatically insert a page break
prior to the first row in the group.

Is this possible?
 
Top