G
Guest
Worksheets("Cost Analysis").Activate
Set UdRng = ActiveSheet.Range("F10:F38")
UdRng.Formula = "=IF(AND(A10>0, H10>0),"EQ","")" << occuring here
ActiveSheet.Range("A9:G38").Select
Selection.AutoFilter
Help appreciated
Set UdRng = ActiveSheet.Range("F10:F38")
UdRng.Formula = "=IF(AND(A10>0, H10>0),"EQ","")" << occuring here
ActiveSheet.Range("A9:G38").Select
Selection.AutoFilter
Help appreciated