Thread: Variable Range Name

Can you name a range based on the value of an adjacent cell? I know this is not an actual function but I thing it explains what I am trying to do. I want a range

Code:

      A      B         C         D        E     F
1  FLM     KW1   KW2    KW3                           
2
3

I would like to be able to define a range with the name = A1 and the range from B1 to D1

I'm trying to set up a workbook with predefined ranges whose name can be defined by user input. So, what ever the user inputs into cell1 becomes the name of the range from B1 to D1.