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