Substraction with VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I need help with a VBA formula that would do "L11" - (minus) "M11" and would
put the result in "N11"
Thanks,
 
Hi
with activesheet
.range("N11").value=.range("L11").value-.range("M11").value
end with
 
Hi
Is this possible ?
..range("N11:N624").value=range("L11:L624").value-range("M11:M624")
Jeff
 
You could use a formula

..Range("N11:N624").Formula = "=L11-M11"

if you don't want to keep the formula put

..Range("N11:N624").Value = .Range("N11:N624").Value

after.
 
Hi
no. But try the following:
with activesheet.range("N11:N624")
.formulaR1C1="=R[0]C[-2]-R[0]C[-1]"
.value=.value
end with
 
Back
Top