Not quite following you when you write: " Cell reference of cell B1 should be automatically renamed as "Rfa" (content in A1) and that of B2 as "Rra" (content in A2)." Are you wanting to simply and automatically rename cell B1 Rfa and cell B2 Rra? If you want to auto rename those cells, then what is the prompt to do this? If as Macropod stated, you only want to name those cells then click in the cell you want to name, click Formulas > Name Manager > New then in the name box enter the "range name" you want to assign to that cell. Or click in the cell you want to name, go to the name box (to the left of fx in ribbon) and type the "range name you want to assign to that cell. To check yourself, click on Name Manager and you should see the name you assigned to that cell, along with the cell address. Hope that helps. If this is not what you are wanting to do, take a minute, take a deep breath, sit down, while in Excel go through the steps you want done and at the same time write them down so all can better understand what it is you want to accomplish. See? Best wishes.