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

1 Answers1

0

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

With ActiveWindow
    .SplitRow = 17
    .FreezePanes = True
End With
Spinner
  • 1,046
  • 1
  • 4
  • 15