Assigning Named Ranges to a Variable

[ThreeBullet]

Folks, Please save me from lunatic asylum!

I want to position the focus onto certain specific cells, each of which I have defined as named ranges.

Effectively these are starter cells for distinct sets of calculations. I want to give the user a choice of which starter cell to use.

I want that user choice to be made using option buttons on a UserForm.

The UserForm button selection should assign a range variable to a particular Named Range, each button resetting the range variable to one particular named range.

I understand how to code selecting a particular cell, my problem is solely with assigning the named range to a variable.

All works fine until I run Sub. Then I get an Error 1004 Method 'Range' of object 'Global' failed.

I have tried everything I can for 3 days, but cannot move beyond this point.

Sorry I am new to Forum and can't figure out how to add code here to this message, but the problem should be clear from above.

Three Bullet

 

[Norie]

Why are you selecting these ranges?

Also what do you mean by 'assign' a range variable to a named range?

Do you want to change the range referenced in the named range to the range variable?

Can you post the code?

 

[VoG]

The code should be like this

Set Rng = Range("MyRange")

You can post code like this:

[code]
code goes here
[/code]

 

[Norie]

ThreeBullet

Is the user actually selecting a cell then opening the userform.

Then you want them to choose a named range on the userform.