Thread: Fixed Columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mpho[_2_] Mpho[_2_] is offline
external usenet poster
 
Posts: 5
Default Fixed Columns

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