Macro to Go To a Certain Cell

[John]

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

 

[keepITcool]

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]

Thanks KeepITcool

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]

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

 

[Tom Ogilvy]

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

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

 

[John]

Thanks Tom

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

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