VB Doesn't like my code

[leecavcu]

Can anyone tell me why this doesn't work? I assume it has to do with the double quotes. Tot is defined as a string. new row is defined as an integer.

Tot = "=IF(AND($E" & newrow & "=" - ",$F" & newrow & "=" - ")," - ",$D" & newrow & "*$G" & newrow & ")"

Thanks!

 

[wsjackman]

Can anyone tell me why this doesn't work? I assume it has to do with the double quotes. Tot is defined as a string. new row is defined as an integer.

Tot = "=IF(AND($E" & newrow & "=" - ",$F" & newrow & "=" - ")," - ",$D" & newrow & "*$G" & newrow & ")"

Thanks!

if newrow were 3 would you want this to be
=if(and($E3="-",$F3="-"),"-",d3)

try
Tot = "=IF(AND($E" & newrow & "= "&"" - ""&",$F" & newrow & "="&"" - ""& "),"&"" - ""&",$D" & newrow & "*$G" & newrow & ")"