ExcelBanter - syntax error

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - syntax error - help (https://www.excelbanter.com/excel-discussion-misc-queries/155534-syntax-error-help.html)

Jim May

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

Toppers

syntax error - help

UdRng.Formula = "=IF(AND(A100, H100),""EQ"","""")"

"Jim May" wrote:

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

Jim May

syntax error - help

Guess you need to double-up on the " 's in such a case.
Thanks Toppers

"Toppers" wrote:

UdRng.Formula = "=IF(AND(A100, H100),""EQ"","""")"

"Jim May" wrote:

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

All times are GMT +1. The time now is 07:05 PM.