Autocopy formula to cells

A

ASU

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.
 
A

ASU

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autocopy formula to cells 4
VB Script reference cells for in current table? 1
Autofill formula to next row 4
Cumulative formula for word table 0
Sorting 2
Need Help with a VBA subroutine 0
Macro to copy a Cell Content automatically IF G12 cell <>"" 6
Creating one formula for use in two different cells 2

Top