S
Sesquipedalian Sam
I am trying to write a macro to change the table settings so that:
1. Automatically resize to fit = Off.
2. Rows are not allowed to break across pages.
I started by recording the steps and got this:
With Selection.Tables(1)
.AllowPageBreaks = False
.AllowAutoFit = False
End With
The autofit setting works. The pagebreaks does not.
Do I need to loop through the rows one at a time?
1. Automatically resize to fit = Off.
2. Rows are not allowed to break across pages.
I started by recording the steps and got this:
With Selection.Tables(1)
.AllowPageBreaks = False
.AllowAutoFit = False
End With
The autofit setting works. The pagebreaks does not.
Do I need to loop through the rows one at a time?