Add name problem
 

I want to assign the name "Grafiek" to the selected cells (not the
CurrentRegion like in the code below)

What code should i use ?


ActiveWorkbook.Names.Add Name:="Grafiek", RefersToR1C1:= _
ActiveCell.CurrentRegion


Thanxxx,

Luc

Add name problem
 

Change

ActiveCell.CurrentRegion

to

Selection

In article ,
"Luc" wrote:

I want to assign the name "Grafiek" to the selected cells (not the
CurrentRegion like in the code below)

What code should i use ?


ActiveWorkbook.Names.Add Name:="Grafiek", RefersToR1C1:= _
ActiveCell.CurrentRegion


Thanxxx,

Luc

Add name problem
 

Thanxxx
Luc

"JE McGimpsey" wrote in message
...
Change

ActiveCell.CurrentRegion

to

Selection

In article ,
"Luc" wrote:

I want to assign the name "Grafiek" to the selected cells (not the
CurrentRegion like in the code below)

What code should i use ?


ActiveWorkbook.Names.Add Name:="Grafiek", RefersToR1C1:= _
ActiveCell.CurrentRegion


Thanxxx,

Luc