Thread: syntax error - help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim May Jim May is offline
external usenet poster
  
Posts: 477
Default syntax error - help
Worksheets("Cost Analysis").Activate
Set UdRng = ActiveSheet.Range("F10:F38")
UdRng.Formula = "=IF(AND(A100, H100),"EQ","")" << occuring here
ActiveSheet.Range("A9:G38").Select
Selection.AutoFilter

Help appreciated
Reply With QuoteReply With Quote