NAme range
 

Hi
In a userform i create a new name in a sheet
and the same name create a new sheet whit that name
So far so good

But in my code i use a name on the range in the sheet
Is there a way to create a name to the range in the sheet
i just have made?

Regards alvin

NAme range
 

I have done it sorry

Alvin


"Alvin Hansen" skrev:

Hi
In a userform i create a new name in a sheet
and the same name create a new sheet whit that name
So far so good

But in my code i use a name on the range in the sheet
Is there a way to create a name to the range in the sheet
i just have made?

Regards alvin