VBA Code Bug
Try
NewSht.Range("K72") = OldSht.Range("K69") - OldSht.Range("K70") -
OldSht.Range("K71")
OR
NewSht.Range("K72") = OldSht.Range("K69") - (OldSht.Range("K70") +
OldSht.Range("K71"))
If this post helps click Yes
---------------
Jacob Skaria
"Jim" wrote:
I'm having a run time error with this code:
NewSht.Range("K72") = OldSht.Range("K69" - "K70" - "K71")
Suggestions?
|