Returning the range name in VBA

  • Thread starter Thread starter John Tjia
  • Start date Start date
J

John Tjia

I just got another tip which is similar to yours, Tom:

If ActiveCell.Name.NameLocal="Revenue" then ...

What might the difference be between .Name and .NameLocal
 
If you're using the English version of Excel, none. If a foreign language, it
should return the name in that language. But presumably the user would have
used his native tongue when setting up the name.
 
I doubt it does much of anything except perhaps with built in names like
Database or Print_Area. then it might translate them to the name used in
that local. (I don't know, I don't have access to other than US English)
For a name like "ABCD" or "Revenue" I doubt it would do anything.
 
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

Creating a local and hidden name; Parameters 13
Named Ranges 4
Using VBA to copy a Chartsheet to Powerpoint 2
Returning the range name in VBA 4
VBA - retrieve data on last create named range from previous inserted named range 0
range names 4
Gather Data from Multiple Sheets 1
Post my named ranges in column A 10

Back
Top