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.
Range(Selection.Address).Select
Selection.ListNames
Doesn’t show anything
Expected results:
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.