How do you get a Range to return its Name?

by

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

More Related Contents:

  1. How can I call a macro which contains a loop but only run one iteration of that loop?
  2. VBA comma separated cells, needt last entry only
  3. How can I find last row that contains data in a specific column?
  4. Open Excel file for reading with VBA without display
  5. Wait for shell command to complete [duplicate]
  6. How to return the number of dimensions of a (Variant) variable passed to it in VBA [duplicate]
  7. How to add a named sheet at the end of all Excel sheets?
  8. How to remove all non alphanumeric characters from a string except period and space in excel?
  9. Find last used cell in Excel VBA
  10. VBA general way for pulling data out of SAP [closed]
  11. Does Dir() make any guarantee on the order of files returned?
  12. Call a Sub with a String
  13. Assign on-click VBA function to a dynamically created button on Excel Userform
  14. What are .NumberFormat Options In Excel VBA?
  15. Excel: How to check if a cell is empty with VBA? [duplicate]
  16. ShowAllData method of Worksheet class failed
  17. Assign keyboard shortcut to run procedure
  18. return csv file as recordset
  19. Excel macro -Split comma separated entries to new rows [duplicate]
  20. Get text from clipboard using GetText – avoid error on empty clipboard
  21. Benchmarking VBA Code
  22. The MacScript function is not working well in Office for Mac 2016! Any ideas?
  23. Display milliseconds in Excel
  24. VBA editor auto-deletes spaces at the ends of lines
  25. Application.Quit command not closing the entire Excel Application
  26. Trying to open the workbook in separate instance
  27. Excel VBA – select multiple columns not in sequential order
  28. How to check whether certain sheets exist or not in Excel-VBA? [duplicate]
  29. Excel – Using COUNTIF/COUNTIFS across multiple sheets/same column
  30. Excel telling me my blank cells aren’t blank

Leave a Comment