I'm new to VBA, trying to learn more by converting old macro.
The function "=FORMULA.GOTO?()" in Excel XLM is same as the "Go To" command in Excel. It will open a dialog box with all range names created in the workbook. The user can scroll the up-down bar to select **ANY** range name to goto without typing the reference.
The VBA command (Application.Goto Reference:=) only goto the specified range.
What will be the equivalent function/command in VBA to give you the choice to goto without typing?
Thanks to your help.
The function "=FORMULA.GOTO?()" in Excel XLM is same as the "Go To" command in Excel. It will open a dialog box with all range names created in the workbook. The user can scroll the up-down bar to select **ANY** range name to goto without typing the reference.
The VBA command (Application.Goto Reference:=) only goto the specified range.
What will be the equivalent function/command in VBA to give you the choice to goto without typing?
Thanks to your help.