Returning the range name in VBA

  • Thread starter Thread starter John Tjia
  • Start date Start date
You have a good solution, but just to answer on of your questions.

Activecell.Name.Name

returns the range name if it has one, otherwise it raises an error.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return sheet name from an address range 2
Row and column count last occupied cells in range 2
COUNTIF accross multiple worksheets issues 4
Dynamic Chart Range 2
VBA set thick borders around non empty cells in range 0
Creating a VBA Range object from Excel HYPERLINK workbook function 1
renaming named ranges 4
strange VBA behavior with named ranges 5

Back
Top