Sunday, April 10, 2022

Freeze the top row using vba

 
    Rows("1:1").Select
    With ActiveWindow
        .SplitColumn = 0
        .SplitRow = 1
    End With
    ActiveWindow.FreezePanes = True

No comments:

Post a Comment