formula in VBA
On Fri, 11 Jul 2008 14:31:56 -0700, Tim Zych wrote:
.Cells(lNextRow, "N").Formula = _
"=IF(I" & lnextrow & "<"""",IF(J" & lnextrow & _
"<"""",SUM(J" & lnextrow & ":L" & lnextrow & _
")*I" & lnextrow & "+M" & lnextrow & ",""""),"""")"
Thanks!
|