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

Topic

New Reply

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

Reply | Quote

Replies

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

Reply | Quote

You can use this:

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

It will also set AA2200 as the active cell.

Reply | Quote

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

Reply | Quote