activecell position

[ac3100]

using a macro, I select a cell in another sheet. I want the sheet to position itself so that the active cell appears in the upper left corner just below a split. The problem is when the cell is selected, it positions itself in the middle of the sheet.
Hope this makes sense.
Andy
This message was edited by ac3100 on 2002-08-22 15:33

 

[Juan Pablo González]

This worked ok:

Application.Goto ActiveCell, True

 

[ac3100]

Thank You Juan.

It works great!

Andy