How to avoid using `Select` when freeze panes for the first two rows?

Viewed 50

I heard a lot that using Select should be avoided as it slows code.
on the below code I want to freeze panes for the first two rows and I did not find any way to not using Select.

Sub Freeze_first_two_rows()
 
    ActiveWindow.FreezePanes = False
 
    ActiveSheet.Rows(3).Select
 
    ActiveWindow.FreezePanes = True
 
End Sub
0 Answers
Related