place a named cell in the top left corner of the worksheet

[Paul Condron]

I am writing a simple routine but am a novice at this. I want to 'go to'
various named cells and I always want the cell I go to, to be positioned at
the top left hand corner of the worksheet. E.g. a:1 or aa:100 or BB:500. Can
anyone help please?

[JE McGimpsey]

one way:

Application.GoTo Range("namedcell"), Scroll:=True

In article <66A40566-A0B4-45F7-AFBF-0E0D48D652C2@microsoft.com>,
Paul Condron <Paul Condron@discussions.microsoft.com> wrote:

> I am writing a simple routine but am a novice at this. I want to 'go to'
> various named cells and I always want the cell I go to, to be positioned at
> the top left hand corner of the worksheet. E.g. a:1 or aa:100 or BB:500. Can
> anyone help please?

[Paul Condron]

Thank you very much.

"JE McGimpsey" wrote:

> one way:
>
> Application.GoTo Range("namedcell"), Scroll:=True
>
> In article <66A40566-A0B4-45F7-AFBF-0E0D48D652C2@microsoft.com>,
> Paul Condron <Paul Condron@discussions.microsoft.com> wrote:
>
> > I am writing a simple routine but am a novice at this. I want to 'go to'
> > various named cells and I always want the cell I go to, to be positioned at
> > the top left hand corner of the worksheet. E.g. a:1 or aa:100 or BB:500. Can
> > anyone help please?
>