Help with VBA syntax for entering Formula

[jim may]

Hi guys -- it has been a few years since I needed to write a line of CODE like the below. Currently it is returning "TRUE"
versus the actual formula in the cells. Can someone point out the obvious error. Thanks in Advance.. Jim

With Selection
.Formula = "=SUMIFS(DetailsByDay!D:D,DetailsByDay!A:A," >= "&DetailsByDay!F$2,DetailsByDay!A:A,""<=""&DetailsByDay!F$3),DetailsByDay!C:C,Invoice!B29)"
End With

 

[Fluff]

How about

With Selection
.Formula = "=SUMIFS(DetailsByDay!D:D,DetailsByDay!A:A,"">=""&DetailsByDay!F$2,DetailsByDay!A:A,""<=""&DetailsByDay!F$3,DetailsByDay!C:C,Invoice!B29)"
End With

 

[jim may]

How about

With Selection
.Formula = "=SUMIFS(DetailsByDay!D:D,DetailsByDay!A:A,"">=""&DetailsByDay!F$2,DetailsByDay!A:A,""<=""&DetailsByDay!F$3,DetailsByDay!C:C,Invoice!B29)"
End With

Fluff -- Thanks so Much - I failed to consider the Duplicate double-quotes... Jim

 

[Fluff]

You're welcome & thanks for the feedback.