Define Name to current selection

[azureriders]

Bumping this tread, I thought I was good when I found it via search, but no luck when I ran it.

http://www.excelforum.com/excel-prog...selection.html

Please Login or Register  to view this content.

I get no error, nor a new name. It is like I have never ran it. Any help?

[dominicb]

Good evening azureriders

Please Login or Register  to view this content.

I get no error, nor a new name. It is like I have never ran it. Any help?

Try altering your syntax slightly - this seems to work OK :

Please Login or Register  to view this content.

HTH

DominicB

[shg]

In your syntax, you are creating a named formula, and formulas need an equals sign:

Please Login or Register  to view this content.

[azureriders]

Please Login or Register  to view this content.

Worked like a charm, thanks again.



Shg,
Thanks for the effort, but for some reason your code ran the same as mine. No error, however no new name as well.


If I can still mark this thread as solved, I am obviously missing how. Mods feel free to do so please.