inserting formula
Dave,
You only need to use the concatenators where you're substituting the
variable lPrevSumRow for the row number.
Try this (all on one line)...
"=IF(G" & lprevsumrow & "<"""",DATEDIF(G" & lprevsumrow & ",H" &
lprevsumrow & ",""d"")+1,"""")"
NickH
|