Browse to given cell location

how can I select a given  cell location

e.g: WC2000


thanks
 
LVL 1
drnadeemAsked:
Who is Participating?
 
criConnect With a Mentor Commented:
Within VBA Excel/97, one alternative is:

Sub TryThis()
    ActiveSheet.Range("CW2000").Select
End Sub

However, as "WC2000" does not exist and you might need a hyperlink, an auto-open macro, etc., please state what you actually want to accomplish.


0
 
macbone2Commented:
Right, I know this but is there a way to make a selected range the top left cell in focus?
0
 
criCommented:
Sub TryThis()
   'Replace ActiveSheet by the appropriate worksheet
   Application.Goto reference:=ActiveSheet.Range("c5:e10"), Scroll:=True
End Sub
0
 
macbone2Commented:
Thanks cri. Yeah I discovered this yesterday (with the aid of an amateur at the office) I must have been having a brainstorm, it never occurred to me to record a macro with F5 (find range)Dumb or wot

macbone2
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.