Results 1 to 5 of 5

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

Threaded View

  1. #1
    Valued Forum Contributor AlvaroSiza's Avatar
    Join Date
    09-19-2007
    Location
    Staffordshire
    MS-Off Ver
    2007
    Posts
    591

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

    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
    ToFlexHome
    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
    Last edited by AlvaroSiza; 09-09-2011 at 09:32 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1