Position cell in top left position

**Hein** · 01-07-2009, 05:34 AM

Hi all

Is it possible to position a predetermined cell (e.g. A42) in the top left corner of the screen.

(Not every screen users use has the same size)

Thanks in advance
Hein

**Richard Schollar** · 01-07-2009, 05:38 AM

Hi Sure:

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

Richard

**royUK** · 01-07-2009, 05:39 AM

Try this

Option Explicit

Private Sub Workbook_Open()
Application.Goto Sheet1.Range("a42"), True
End Sub

**Hein** · 01-07-2009, 05:48 AM

Both methods works!
(The scroll part doesn't seem to make any difference)

I knew that, when scroll is on and you use the home key it has the same effect
Problem is that you can't record it

Thanks Roy and Richard!

Hein

Position cell in top left position

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Position cell in top left position

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions