Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Getting Data To View Properly For Multiple Users (Excel 2000 2003)

    I have an Excel Workbook. It is being used by a large group of users. Worksheet 1 is an input template where the users include the needed data.
    Worksheet 2 as currently set up generates a report at range AA2000..AJ2052.
    I have already created a Macro that gets the proper results but I am having trouble getting Excel to position cell AA2000 on all users screens the same as Cell A1 does on all blank sheets. Can anyone assist with the easiest method to have this occur.
    In other words, when the Maco is done I want cell AA2000 as the cell at the top left corner of the screen.

    Regards,

    Tom Duthie

  2. #2
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Getting Data To View Properly For Multiple Users (Excel 2000 2003)

    Tom,

    Would it be feasible to place cell AA2000 in the upper left corner and then apply "Windows>Freeze Panes" say to cell AB2001?

    Regards,
    John

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Getting Data To View Properly For Multiple Users (Excel 2000 2003)

    You can use this:

    Application.Goto Reference:=Range("AA2200"), Scroll:=True

    It will also set AA2200 as the active cell.

  4. #4
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Re: Getting Data To View Properly For Multiple Users (Excel 2000 2003)

    Hans:

    Just what I was searching for !
    Not having to move the range to another worksheet or to the top of the active worksheet is a real time saver.

    Tom Duthie

Posting Permissions

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