I want to setup a macro for users to define named ranges in several sheets
and name the range whatver they enter into a certain cell in that sheet e.g:

Range("B15:K15").Select
ActiveWorkbook.Names.Add Name:="_1A", RefersToR1C1:= _
"=TEMPLATE!R15C2:R15C11"
Where "_1A" is the user entry into a specific cell which will be the same
cell in each sheet. When i record the macro it puts in "_1A" each time - how
do i get it to link to the variable cell contents?

Thanks,