Displays a list of range names for a worksheet on another worksheet in Excel VBA
In a workbook there are 2 worksheets, Detail and Group. In the Group sheet there are 3 ranges, “mk_1”, “mk_2”, and “mk_3” with worksheet scope.
How to display listnames of the three ranges on the Group sheet in the Details sheet in Excel VBA.