Hi guys,
I'm getting a Run Time Error 1004, Application-defined or object-defined Error in the formula below.
I've tried almost everything except the right thing, can you find it???
VB Code:
ActiveCell.Offset(0, 4).Formula = "=IF((" & ActiveCell.Offset(0, 2).Address & "<" & ActiveCell.Offset(0, 3).Address & "),"",(" & ActiveCell.Offset(0, 2).Address & " / (" & ActiveCell.Offset(0, 2).Address & "-" & ActiveCell.Offset(0, 3).Address & "))-1)"
thanks




Reply With Quote