How to obtain name of range with VB code

[B F Cole]

I need to obtain the name of a selected range.

For example:

sColName as String

Columns(4).Select ' Select column D

sColName = ????? ' What is the syntax to return the name previously
assigned to the column?


Thanks for your usual fine response.
Bill

 

[Gary Keramidas]

try this in the immediate window when the range is selected

in the vb editor:
control-g to make the window visible if it's not already
then enter the following and press enter
?selection.name.name

 

[Guest]

After highlighting (selecting a prviously named Rangename)
From the immediate window:

? Selection.name.name

returns the string name

 

[B F Cole]

Thanks. It worked. I left off the second .name

Bill