use the INDIRECT function

=INDIRECT("C1") * INDIRECT("B1")



-----Original Message-----
Hi! Excel programmers,I have a problem with cells.

Problem
I have a formula in cell A1 which is B1*C1,problem is if
i
select lets say column B and insert a column, the
formula
in cell A1 changes to C1*D1 and which is not what i
want.I
would like to make this formula to stay constant even i
add columns.

Thanks a lot, your help it is highly appreciated.

Mpho

.