Hi Jennifer,
In a sense the 'With Selection.Tables(1) .. End With' block does act as if the table were selected. Since your selection point is already within the table, that's all that's needed.
Quote:
|
The other change that I noticed is you changed my test from "<> True" to "= False". Is there a reason for that?
|
Only that your SettingHeaderRowOld variable returns True/False, whilst the others were returning On/Off - which amounted to the same thing. AllowAutoFit can only be True/False, though .Rows.AllowBreakAcrossPages (and, hence SettingBreakOld) could be True/False/Undefined - the latter if some rows were allowed to break and others weren't.