you can create a Name for that cell that can be used in the workbook to reference that cell. For example if the worksheet contains Sales Data and the cell in question is the total of sales for all sales staff it may called TotalSales. Then wherever we need to use that value we can refer to the name rather then the specific cell reference.