Probably too simple but I am stuck. I have a combo box that returns the necessary value eg 4. Now by a strange quirk I have found that if I mutipy my answer by 4 and add 20 it will always give me a reference to the correct row of cells which I would like to graph, my dilema is how do I concatenate a Column heading with the result to return a cell address in a formula. ="C" & A1 returns me C24 but if I try to use this it returns a #VALUE!