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..
 
Yeah, this was intended for the Excel - Misc Group - donno what happened !!
Sorry
 
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

syntax error - help 2
Windows XP Array / SUMPRODUCT error 0
Out of Memory Message - Code Problem? 4
How to stop a progressive array formula? 0
Error Number: 91 object variable or With block Variable not set 1
Run-Time error '9' Subscript out of Range 7
Syntax error in INSERT INTO statement 10
Big Problem, can't get sheet to calc correctly 3

Back
Top