Simple vba question.

[vbacoder12]

I have an option explicit sub which is running a series of subs one of my last subs is to freeze panes. Some times it freezes the correct amount of panes some times not. Also if I run this outside of the option explicit sub it works fine here is the vba

Sub freezerow
'
' freezerow macro
'
'
With ActiveWindow
.splitcolumn=3
.splitrow=6
End With
ActiveWindow.Freezepanes=TRUE
End Sub

 

[MARK858]

Sorry I didn't even know anything about my profile.

You can amend it by clicking where your username and profile pic is at the top of the page and then click "Account details". Remember to save it before exiting.

between application.goto reference:=activesheet.range ("a1"),scroll:true

That a single line and so I don't know exactly where you are putting the code and why you need to use it on top of the

    Application.Goto Reference:=ActiveSheet.Range("D7")
    With ActiveWindow
        If .FreezePanes = True Then .FreezePanes = False
            .FreezePanes = True
    End With

that Alex posted.
Unless you specifically need split windows over Freeze panes (they are different) that you asked for in post one can you please post your current code (and state what issue you had with Alex's code).

I have another question about another code that isn't working way is thought should I create a new post

If it is related to splitting windows or freezing panes then you can post it here, if it is not related then you should start a new post