Creating a cell name from another cell
 

I'm very new to creating VBA code so what I would like help with is this
problem. I'm trying to create a name for a cell that incorporates another
cell contents and the words "Grand_Total_". My thoughts are along the lines
of trying to develop code that creates the new name that I want (e.g
Grand_Total_Bandage) by joining the cell with the contents of Bandage to the
words "Grand_Total_" and then use this for the cell name. What I can't work
out is how to reference the contents of the cell I want and then add it to
the Grand_Total_. I'm pretty sure I know how to add the results to the other
cell that I want to name using VBA code.

Any assistance would be most appreciated.

Insp G