Question : get name of a range vba
Answered by : alex-lanaro-14ziv22qcwmq
'For a Range, Name isn t a string it s a Name object
'that you then take the Name property of to get the string
MsgBox sampleRange.Name.Name
Source : https://stackoverflow.com/questions/3630496/how-do-you-get-a-range-to-return-its-name | Last Update : Sat, 03 Oct 20