Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Hayfa Khan   on Aug 10 In MS Office Category.

  
Question Answered By: Sophie Williamson   on Aug 10

I really did think there was a menu/shortcut way to do this. However, for
those who want to....

Sub subGoToAddress()

Dim slAddy As String
Dim slSheet As String
Dim slCell As String

slAddy = Mid(Selection.Formula, 2)
slSheet = Mid(slAddy, 1, InStr(slAddy, "!") - 1)
slCell = Mid(slAddy, InStr(slAddy, "!") + 1)
Sheets(slSheet).Activate
Range(slCell).Select

'
****************************************************************************
End Sub

... And pasted on a button seems to work fairly well.
There is no checking done though to see if the formula  really is an address.

Share: 

 

This Question has 4 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on 2003 - Moving to a formula address Or get search suggestion and latest updates.


Tagged: