syntax error - help

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't Complete with out getting syntax error 2
Macro/VB coding question 3
Paste Filtered Range to New Workbook- AS 2
VB Error when AutoFiltering a Pivottable 1
Help me4 2
Bypass a function in a Macro 3
Excel Macro to use cells as a autofilter 0
Macro Error 1004 3

Back
Top