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 can I display listnames of the three ranges on the Group sheet in the Details sheet in Excel VBA.
<code>Range(Selection.Address).Select
Selection.ListNames
</code>
<code>Range(Selection.Address).Select
Selection.ListNames
</code>
Range(Selection.Address).Select
Selection.ListNames
Doesn’t show anything
Expected results:
<code>mk_1
mk_2
mk_3
</code>
<code>mk_1
mk_2
mk_3
</code>
mk_1
mk_2
mk_3
New contributor
mps info is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.