John()
Member
Ok was doing a macro for someone who posted in this forum .... when the following occurance effects how it works
and was wondering dose it happen with other peoples excel or just mine
have a simple formula in column C ... =B1+A1
which i then drag down for say 10 rows .... now i fill row A with numbers down to row 10 and they as expected appear in Column C ...... Problem is when i add a value to A11 it also appears in Colum C11 even though i dindnt add the fromula to that cell (it automatically adds the formula to the cell)
and if i continue adding values in Column A they keep appearing in Column C
so did a little investigating and found if i only dragged the formula down three rows in Column C ... excel behaved the way i expected eg add values to A1 A2 and A3 they appear in Column C ... add a value in A4 no value appears in C4
But if i drag the formula down to C4 then it will keep on adding the values to column C when i add them in A5 down (it also adds the formula in column C)
Closed down all work books and restarted excel and still it happens
Using 2007 version
Any thoughts ?????
and was wondering dose it happen with other peoples excel or just mine
have a simple formula in column C ... =B1+A1
which i then drag down for say 10 rows .... now i fill row A with numbers down to row 10 and they as expected appear in Column C ...... Problem is when i add a value to A11 it also appears in Colum C11 even though i dindnt add the fromula to that cell (it automatically adds the formula to the cell)
and if i continue adding values in Column A they keep appearing in Column C
so did a little investigating and found if i only dragged the formula down three rows in Column C ... excel behaved the way i expected eg add values to A1 A2 and A3 they appear in Column C ... add a value in A4 no value appears in C4
But if i drag the formula down to C4 then it will keep on adding the values to column C when i add them in A5 down (it also adds the formula in column C)
Closed down all work books and restarted excel and still it happens
Using 2007 version
Any thoughts ?????