Using variables in For i= loop

[Yamezz]

I get a Run-time error '6': Overflow message on the following line of code.

For i = StartReportDate To EndReportDate + 1

Both variables are declared as long and correctly evaluate to 45419 and 45425 respectively via

StartReportDate = CDbl(CDate(Left(PaymentReport.ActiveSheet.Range("A" & Rows.Count).End(xlUp).Value, 10)))
EndReportDate = CDbl(CDate(Left(PaymentReport.ActiveSheet.Range("A2"), 10)))

I intend to use the loop to examine each date between the Start and (end of)End date - hence the "+1"
What am I doing wrong?

 

[Alex Blakenburg]

Does it make a difference if you declare i as Long ?
Ref: Data type summary

 

[Yamezz]

It does, Alex. I'd be lost without you guys and this forum!
Thanks.

 

[Alex Blakenburg]

No worries. Happy to help.