Excel size

[agibsonsw]

Hello. Excel 2003.

Someone has about 20 sheets which each cover about 100 rows and columns containing many formulas. There is also some VBA.

Does a size of 8MB seem big for such a file?

Separate question: What is the instruction that makes a certain cell occupy the top left corner of the viewable area? I've forgotten it

Thanks, Andy.

[StuartR]

8MBytes sounds pretty big to me

Try clearing all the rows below and to the right of your data to see if that helps.

To scroll cell (5,6) to the top left of the screen try the following Visual Basic...

ActiveWindow.ScrollIntoView Left:=Cells(5,6).Left, Top:=Cells(5,6).top, Width := 100, Height:= 100

[HansV]

That file size is not surprising.

To display cell Q37 in the upper left corner:

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

This even works if the cell is on on another worksheet. The sheet will be activated if necessary:

Application.Goto Reference:=Worksheets("OtherSheet").Range("Q37"), Scroll:=True

[HansV]

8MBytes sounds pretty big to me

[agibsonsw]

Thanks both. Andy.