name a cell irrespective of its value

Yes, but you can use that cell for calculation purposes & also the cell does not display the value though it has the product (A1*A2) in it

Hi Cbratrody,

i will keep that as the backup plan if i do not find any other solution

cheers

ananth