• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

Browse to given cell location

how can I select a given  cell location

e.g: WC2000


thanks
 
0
drnadeem
Asked:
drnadeem
  • 2
  • 2
1 Solution
 
criCommented:
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now