Passing Value to a Name Range / Name Manager

[Chino21]

Hi guys,
One quick question is there a away or is it possible to pass a value in a Named range.

I have a named range (twinsnames)

=OFFSET('TWIN SUP'!$C$1,0,0,COUNTA('TWIN SUP'!$C:$C),1)

is there a way that this code will be transfered/passed to my name range. Planning to put it at the end of my code.


To explain:

1. Program starts
2. Enter value needed for the program
3. Save information
4. Instruct the program to copy the code to named range
5. End program.

Hope somebody can help me out

 

[C Moore]

I don't understand what you want the output to be.