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

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?

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

one way:

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

In article ,
Paul Condron <Paul 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?

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

Thank you very much.

"JE McGimpsey" wrote:

one way:

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

In article ,
Paul Condron <Paul 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?