Assume a command button is used to call a sub which navigates to a range. Assume the target range is FlexHome.
Is there any reason I should not be using
Application.Goto Reference:="FlexHome", Scroll:=True
in place of calling
through which
Application.ScreenUpdating = False
Range("FlexHome").Select
With ActiveWindow
.ScrollColumn = ActiveCell.Column
.ScrollRow = ActiveCell.Row
End With
Application.ScreenUpdating = True
is run?
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?
Many thanks!
~AS
Bookmarks