| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last cell in new formula
Thanks for the feedback. Try
Dim lngLastRow As Long lngLastRow = Worksheets("sheet1").Cells(Rows.Count, "N").End(xlUp).Row Range("N" & lngLastRow + 1).Formula = _ "=Sumproduct((N8:N" & lngLastRow & "=0)*(N8:N" & lngLastRow & "<=1000))" -- Jacob "wynand" wrote: THANKS GUYS, BOTH WORK PERFECT! If I would like the "b2" result to be always be under the last cell e.g. N16, what would you suggest " |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
| Subtract cell formula from existing cell formula | Excel Programming | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Question: Cell formula or macro to write result of one cell to another cell | Excel Programming | |||
Threaded Mode
