You need INDIRECT, Jan.
http://www.officearticles.com/excel/...ft_excel.h tm
************
Anne Troy
www.OfficeArticles.com

"jan" wrote in message
...
Result of a formula is in a format of cell reference (ex: c5) which i want
to
use in another formula. But the formula where I am using the cell
reference
is not treating the same as a cell reference. can anybody help me ?