Extract the defined name from a cell

**Phil_V** · 06-10-2009, 08:56 AM

So on my Excel spreadsheet I can select cell B2 of Sheet1 and using the name box give that cell a name such as "Important_Cell".

I know using VBA I can access the cell using the name, such as:

Please Login or Register  to view this content.

But can I get that name FROM the cell?

I have tried the following:

Please Login or Register  to view this content.

But all that gave me in name_string was:

"='Sheet1'!$B$1"

Is there anyway to extract the actual defined name?

Thanks

**romperstomper** · 06-10-2009, 09:00 AM

Close:

Please Login or Register  to view this content.

**Phil_V** · 06-10-2009, 09:04 AM

That works great, but I don't understand why

Can you explain why you need to double the .Name ?

Thanks

**romperstomper** · 06-10-2009, 09:09 AM

The initial .Name returns the Name object, and because you didn't specify what property you wanted, you get its default Value property. You actually wanted the name of the Name object!