software

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?

one way:

Application.GoTo Range(quot;namedcellquot;), Scroll:=True

In article gt;,
Paul Condron lt;Paul gt; wrote:

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

Thank you very much.

quot;JE McGimpseyquot; wrote:

gt; one way:
gt;
gt; Application.GoTo Range(quot;namedcellquot;), Scroll:=True
gt;
gt; In article gt;,
gt; Paul Condron lt;Paul gt; wrote:
gt;
gt; gt; I am writing a simple routine but am a novice at this. I want to 'go to'
gt; gt; various named cells and I always want the cell I go to, to be positioned at
gt; gt; the top left hand corner of the worksheet. E.g. a:1 or aa:100 or BB:500. Can
gt; gt; anyone help please?
gt;