Nelson78
Well-known Member
- Joined
- Sep 11, 2017
- Messages
- 526
- Office Version
- 2007
Hello everybody.
Something is getting wrong in the following operation:
The result is nothing (no errors, no "0").
The problem should be the dates management.
In my macro I have:
In the column rnglav.Offset(0, 30) I have the dates in format number
Any ideas?
Something is getting wrong in the following operation:
VBA Code:
Cells(4, 5) = Application.WorksheetFunction.SumIfs(rnglav.Offset(0, 8), rnglav, "LONDON", rnglav.Offset(0, 12), "0", rnglav.Offset(0, 30), ">=" & startdate, rnglav.Offset(0, 30), "<=" & enddate)
The result is nothing (no errors, no "0").
The problem should be the dates management.
In my macro I have:
Code:
Dim startdate As Double, enddate As Double
In the column rnglav.Offset(0, 30) I have the dates in format number
Code:
rnglav.Offset(0, 30).NumberFormat = "0"
Any ideas?