Cell border before page break

  • Thread starter Thread starter Pygmalion
  • Start date Start date
P

Pygmalion

Hello experts!

Is it somehow possible to tell Excel to put bottom cell border to the
last cell before each page break?

Thanks for the answer.

Regards.
 
try
Sub dopagebrk()
With ActiveSheet
For i = 1 To .HPageBreaks.Count
.HPageBreaks.Item(i).Location.Borders(xlEdgeBottom).LineStyle =
xlContinuous
Next i
End With
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Dynamic border formatting based on dates. Use VBA? 1
Space round text in cells 0
Does borders exist ? 2
Row heights change when printing bug? 1
Trouble with a page break 1
Conditional Formatting - Border Problem 2
Cant format border? 5

Back
Top