Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    RE: Sheet View (XP SP1)

    I have a macro that jumps to a sheet and I'd like to view of the sheet with, for example, cell A129 in the top left corner with the cursor positioned on this cell. Can anyone advise me what lines of code will achieve this. Many thanks.

    Farmer

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: RE: Sheet View (XP SP1)

    The following should do that:

    <pre> Application.Goto Range("A129"), True
    </pre>

    Legare Coleman

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: RE: Sheet View (XP SP1)

    Use Application.Goto with the optionalScroll paramter set to True:

    Sheets("Sheet3").Select
    Application.Goto Reference:="R129C1", Scroll:=True
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: RE: Sheet View (XP SP1)

    Many thanks, that did the trick.

    Farmer

  5. #5
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: RE: Sheet View (XP SP1)

    Ok, how about top left corner is cell A129 but cursor rests in, say, D130?

    Farmer

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: RE: Sheet View (XP SP1)

    Application.Goto Reference:=Range("A129"), Scroll:=True
    Range("D130").Select
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: RE: Sheet View (XP SP1)

    Many thanks again.

    Farmer

Posting Permissions

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