I would use Application.GoTo

Also, is there any reason that
Application.Goto Reference:="FlexHome", Scroll:=True
should be placed in a module and called versus placing the code directly at the worksheet level?
I don't understand the question.