Can't Complete with out getting syntax error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In case someone insert new rows where I previouly have Col F hidden
with formulas in Cells F10 contiguous thru F38 (lines 2 & 3 below attempt
to add formulas to new cells.
.......
Worksheets("Cost Analysis").Activate
Set UdRng = ActiveSheet.Range("F10:F38")
UdRng.Formula = "=IF(AND(A10>0, H10>0),"EQ","")" '<< Can't compile Syntax
ActiveSheet.Range("A9:G38").Select
Selection.AutoFilter
.........

But I'm getting problem above on specified line.
Any help appreciated..
 
Back
Top