General Navigation Best Practice Question: Application.GoTo vs. Range.Select

Originally Posted by shg

I don't understand the question.

Thanks Shg from one Texan to another. I'm green as grass and apologize if this is elementary.

I guess I'm just verifying that the code should be in the worksheet (Right-Click Command Button >> View Code >> Code Location) like

Private Sub CommandButton1_Click()
Application.Goto Reference:="Flex1Home", Scroll:=True
End Sub

versus

Private Sub CommandButton1_Click()
ToFlexHome
End Sub

Where ToFlexHome equals:

Sub ToFlexHome
Application.Goto Reference:="Flex1Home", Scroll:=True
End Sub