Link to home
Create AccountLog in
Avatar of Peter Chan
Peter ChanFlag for Hong Kong

asked on

Remove page break

Hi,
There is one page break between Column A and column B below. How to remove the page break?User generated image
ASKER CERTIFIED SOLUTION
Avatar of akb
akb
Flag of Australia image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Avatar of matrix8086
matrix8086
Flag of Romania image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Professor J
Professor J

run this in a module.

Sub test()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets

ws.Cells.PageBreak = xlPageBreakNone

Next ws
End Sub

Open in new window

or if you want it automatic , when everytime excel opens then

Private Sub Workbook_Open()

Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets

ws.Cells.PageBreak = xlPageBreakNone

Next ws


End Sub

Open in new window

If you put the file into Page Break Preview mode, the fixed page breaks will be a solid line and the variable breaks based on page size and print settings will be hashed lines.