Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Any know how to fix this overflow error? Cell A1 has a date value of "01/01/2200".
Sub errTest() Dim d1, currDay As Date Dim r As Integer currDay = Date d1 = Sheet1.Range("A1").Value r = currDay - d1 - 7 ' Error because A1 = 01/01/2200 msgbox r End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Overflow Error | Excel Programming | |||
Overflow Error | Excel Programming | |||
overflow error | Excel Programming | |||
Overflow error | Excel Programming | |||
Help! Overflow Error 6 | Excel Programming |