Autocopy formula to cells
 

Can some one tell me whats wrong with this vb code.
As data is entered in cells "A11:G11". Formulas from cells "I10:L10" are
copied and pasted to cells below. In this case"I11:L11". and so on.
--
ASU

Autocopy formula to cells
 

Sorry ....silly me. Here is the code

tr=target.row
if target.column<1 then exit sub
range(cells(tr-1,"i"),cells(tr-1,"l")).copy cells(tr,"i")

--
ASU


"ASU" wrote:

Can some one tell me whats wrong with this vb code.
As data is entered in cells "A11:G11". Formulas from cells "I10:L10" are
copied and pasted to cells below. In this case"I11:L11". and so on.
--
ASU