Formula with VBA problem

[luizmachado]

I have this code where I want get the entire value from a division, for example 7/2 gives me 3.5, not 3 (as the quotient function would give me). It works separately (on the fx line), but I need this to refresh automatically every time some data changes.
It won't go further because of this comma "," between the cells. I don't know what to do to fix it. Do you guys have any idea of what I can do?


Sub Division()
Dim LastRow As Long

LastRow = Cells(Cells.Rows.Count, "I").End(xlUp).Row
Range("I" & LastRow).Formula = "=sum((quotient(E" & LastRow - 1 & ", F" & LastRow - 1 & "), (mod(E" & LastRow - 1 & ",F" & LastRow - 1 & ")/F" & LastRow - 1 & "))"
End Sub

 

[mole999]

you need to call Division, from a Worksheet_Change Event in the macro

you'll probably want to reduce that down to just a column or a few cells when you have tested

 

[luizmachado]

How do I do it? Im kinda new in this VBA thing haha

But would that solve my problem? Because when I try to run it, I get the comma between cells indicators (E" & LastRow - 1 & ", F" & LastRow - 1 & ") selected. I guess that would be the problem.

 

[mole999]

try ; instead of ,

 

[humdingaling]

crosspost
Formula problem with VBA [SOLVED]