0

I have a little code what I want to reform a bit but I don't know that is it possible.

That's why I want some opinion about that can I do it in other way?

Here's the code:

Range("A17").Select
ActiveWindow.FreezePanes = True
Rockraizer
  • 19
  • 8

1 Answers1

0

This will do the same thing, without changing the selection:

With ActiveWindow
    .SplitRow = 17
    .FreezePanes = True
End With
Spinner
  • 1,078
  • 1
  • 6
  • 15