Export Pdf Border Problem

[mohan.r1980]

Hello Friends,

I am making Pdf from Excel.
my excel sheet has data with border, when i export that sheet in pdf then last line of data will not appearing the bottom border of every Page.

i also attached the sample file of pdf

Please suggest me

[OllieB]

You could try to add a dummy blank line below the table and include that dummy line in your output/print selection/area

[mohan.r1980]

thanks OllieB for reply

the above attached sample file, i have write each and every line in Macro and also Select each row for Border.
After finishing writing then i have to export that sheet in Pdf.

Please suggest me

[mohan.r1980]

thanks OllieB for reply

the above attached sample file, i have write each and every line in Macro and also Select each row for Border.
After finishing writing then i have to export that sheet in Pdf.

Please suggest me

[mohan.r1980]

Hello Friends,

How do i know the position of cell when Page Break occur. (That Grid lines)

if there is 5 pages then i just want to know the last cell position of each fist 4 page break.

Please find the attached file.

In attached file my page break is Sr.No.= 39 & 89
First page = Header + 39 Records
Second Page = 40 To 89 records
Third Page = 90th record

so how can i know the position of 39th and 89th records in loop

please suggest me

[mohan.r1980]

I got the solution from Google.

Sub CheckForPageBreaks()
Dim i As Integer

For i = 1 to ActiveSheet.UsedRange.Rows.Count
If Rows(i).PageBreak = xlAutomatic Then
My Code
End If
Next
End Sub