Currently I am using a hyperlink, and it works. See code:
Application.Goto Sheets ("Text").Range ("A47"),True
Is it possible to modify the hyperlink to work like the command button does by having the Range select go to the top?
=HYPERLINK("[Excel Formulas and Functions.xlsm]TEXT!A199","TEXT - Guidelines for Adding Spaces")