Macros to create named range

[Gaurjaya]

Hi,

I want to create named range from selection (left column). Can any one help me with how to write a macros for it.

Thanks in advance

 

[Sixthsense]

[color=darkblue]Sub[/color] CreateNamedRange()
    ActiveWorkbook.Names.Add Name:="MyName", RefersTo:=Selection
[color=darkblue]End[/color] [color=darkblue]Sub[/color]

 

[Gaurjaya]

Hi, Can you explain this. I have an excel sheet where my range to be named is C2:C19, and I want to name these individual cells as the names written in range B2:B19. Can you help me in writting a VBA code for this