Showing posts with label Freeze the top row using vba. Show all posts
Showing posts with label Freeze the top row using vba. Show all posts

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