Beste mensen,
kan onderstaande (2x With.... End With) ook in 1 keer?
kan onderstaande (2x With.... End With) ook in 1 keer?
Code:
ThisWorkbook.Sheets("GEBOUWEN").Activate
With Sheets("GEBOUWEN")
.Cells.Font.Name = "Calibri"
.Cells.Font.Size = 8
.Columns.AutoFit
.Cells.HorizontalAlignment = xlCenter
With ActiveWindow
.SplitColumn = 0
.SplitRow = 1
End With
ActiveWindow.FreezePanes = True
End With
ThisWorkbook.Sheets("HUIZEN").Activate
With Sheets("HUIZEN")
.Cells.Font.Name = "Calibri"
.Cells.Font.Size = 8
.Columns.AutoFit
.Cells.HorizontalAlignment = xlCenter
With ActiveWindow
.SplitColumn = 0
.SplitRow = 1
End With
ActiveWindow.FreezePanes = True
End With