Range Name in VBA

[Ceeyee]

Hi,

I gave a name to cell(2,2) in Excel (not in VBA).

But then when I do msgbox(cell(2.2).name) in VBA, I got "=Sheetname!$B$2"

How to get the name instead of the cell reference?



Thanks.

 

[Vladislav]

use cells(2,2).name.name

 

[Ceeyee]

It works!

How to use VBA to determine if a cell is named?

If I used your .name.name on a un-named cell I will get an object error too.

I want to put in a get-name-only-if-exist check.

Thanks.

 

[Vladislav]

How about...

Function getName(ByVal rg As Range) As String

On Error GoTo errorHandler
getName = rg.Name.Name

exitHere:
Exit Function

errorHandler:
getName = vbNullString
End Function

 

[Ceeyee]

This is great!
Thanks.