| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating a formula with a loop
is there an easier way to create a formula in cell than the following. i want to
show the individual amounts as a formula, don't want zero values, though. ie =20+12+13+6 If IsEmpty(wsA.Range("J" & i)) And cell.Value 0 Then wsA.Range("J" & i).Formula = "=" & wsA.Range("J" & i).Formula & "+" & cell.Value ElseIf cell.Value 0 Then wsA.Range("J" & i).Formula = wsA.Range("J" & i).Formula & "+" & cell.Value End If -- Gary |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help creating Loop | Excel Discussion (Misc queries) | |||
| Need Help With Creating A Loop | Excel Programming | |||
| Creating a formula using the loop variable | Excel Programming | |||
| Creating a formula using the loop variable | Excel Programming | |||
| Creating a For Loop | Excel Programming | |||
Threaded Mode
