Right I think I can describe what I want to do but bear with me.
I have a column with 11 values in it, say a10 to a21. In a10 I have the string "JJcost" and in a11 to a21 i have the numbers 1 to 10.
What I want to do is select any cell between a10 and a21 and then run the macro which will look to the first cell a10 in this case and assign its value to be the name of the range ie "JJCost"
Can anyone point me in the right Direction?
I have a column with 11 values in it, say a10 to a21. In a10 I have the string "JJcost" and in a11 to a21 i have the numbers 1 to 10.
What I want to do is select any cell between a10 and a21 and then run the macro which will look to the first cell a10 in this case and assign its value to be the name of the range ie "JJCost"
Can anyone point me in the right Direction?