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")
|Excel calculate based on 'x' in column||2||25|
|Formatting Undefined Number of Worksheets in a Workbook with VBA Macro||14||39|
|Copying from excel I am getting extra text||11||43|
|how can you record the actions of Document inspector with VBA||3||12|