I'm trying to write a Macro that will go to a certain cell, say A388, that's
easy, but how do I ensure that when I go there via the macro that A388 is
ALWAYS at the top most corner of my worksheet.

Hope that makes sense

Thanks

with an object
application.goto Range("a388"), true
application.goto Range("sheet2!a388"), true


with a string you need r1c1 notation

application.goto "sheet2!R388c1", true



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"John" wrote:

I'm trying to write a Macro that will go to a certain cell, say A388,
that's easy, but how do I ensure that when I go there via the macro
that A388 is ALWAYS at the top most corner of my worksheet.

Hope that makes sense

Thanks

Thanks KeepITcool


"keepITcool" wrote in message
...

with an object
application.goto Range("a388"), true
application.goto Range("sheet2!a388"), true


with a string you need r1c1 notation

application.goto "sheet2!R388c1", true



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"John" wrote:

I'm trying to write a Macro that will go to a certain cell, say A388,
that's easy, but how do I ensure that when I go there via the macro
that A388 is ALWAYS at the top most corner of my worksheet.

Hope that makes sense

Thanks

Another query

Within the same code how can I 'Freeze Panes" - say 2 columns over and 1 Row
down from where the upper left most column resides, that after
application.goto Range("sheet2!a388"), true

Thanks





"keepITcool" wrote in message
...

with an object
application.goto Range("a388"), true
application.goto Range("sheet2!a388"), true


with a string you need r1c1 notation

application.goto "sheet2!R388c1", true



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"John" wrote:

I'm trying to write a Macro that will go to a certain cell, say A388,
that's easy, but how do I ensure that when I go there via the macro
that A388 is ALWAYS at the top most corner of my worksheet.

Hope that makes sense

Thanks

Sub AATester()
Application.Goto Range("sheet2!a388"), True

ActiveCell.Offset(1, 2).Select
ActiveWindow.FreezePanes = True
End Sub



--
Regards,
Tom Ogilvy


"John" wrote in message
...
Another query

Within the same code how can I 'Freeze Panes" - say 2 columns over and 1
Row
down from where the upper left most column resides, that after
application.goto Range("sheet2!a388"), true

Thanks





"keepITcool" wrote in message
...

with an object
application.goto Range("a388"), true
application.goto Range("sheet2!a388"), true


with a string you need r1c1 notation

application.goto "sheet2!R388c1", true



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"John" wrote:

I'm trying to write a Macro that will go to a certain cell, say A388,
that's easy, but how do I ensure that when I go there via the macro
that A388 is ALWAYS at the top most corner of my worksheet.

Hope that makes sense

Thanks

Thanks Tom


"Tom Ogilvy" wrote in message
...
Sub AATester()
Application.Goto Range("sheet2!a388"), True

ActiveCell.Offset(1, 2).Select
ActiveWindow.FreezePanes = True
End Sub



--
Regards,
Tom Ogilvy


"John" wrote in message
...
Another query

Within the same code how can I 'Freeze Panes" - say 2 columns over and 1
Row
down from where the upper left most column resides, that after
application.goto Range("sheet2!a388"), true

Thanks





"keepITcool" wrote in message
...

with an object
application.goto Range("a388"), true
application.goto Range("sheet2!a388"), true


with a string you need r1c1 notation

application.goto "sheet2!R388c1", true



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"John" wrote:

I'm trying to write a Macro that will go to a certain cell, say
A388,
that's easy, but how do I ensure that when I go there via the macro
that A388 is ALWAYS at the top most corner of my worksheet.

Hope that makes sense

Thanks