| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
| Formula works in some cells, doesn't in other | New Users to Excel | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
Linear Mode
