creating a formula with a loop

  • Thread starter Thread starter Gary Keramidas
  • Start date Start date
G

Gary Keramidas

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
 
What you are doing already looks good.

Just be careful of having someing like
=5-2-3
in the cell. Because the result is zero, you will execute the elseif and
loose the "=" sign.
 
ok, thanks. it will always be an addition in this case. the cell value is a
cumulative weight.
 
You must log in or register to reply here.

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

Code not working 3
Make Macro Work On A Different PC 5
Will Macro before a Function like Now() ?? 2
Get count of duplicate strings from autofiltered range 2
vArray = Sheet2.Range("A1:A" & lr) troubles ahoy 11
Object range failed 1
How to get the value from a variable 1
Adding Leading Zeros; Formatting as Time 6

Back
Top