jim may
Well-known Member
- Joined
- Jul 4, 2004
- Messages
- 7,486
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
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