Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Troubleshoot Overflow
I have read that the Overflow Error is frequently associated with
variable declaration. Do you have any suggestions, other than trial and error in changing declarations, for troubleshooting this error? Thanks for your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Troubleshoot Overflow
Formulate expresions to demand Double or Long math:
Sub bad_math() MsgBox (24 * 60 * 60) End Sub will fail on overflow, but: Sub good_math() MsgBox (24# * 60 * 60) End Sub will work just fine. -- Gary''s Student - gsnu200785 "JingleRock" wrote: I have read that the Overflow Error is frequently associated with variable declaration. Do you have any suggestions, other than trial and error in changing declarations, for troubleshooting this error? Thanks for your help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Troubleshoot Overflow
hi
nope. this is one case where experience really does help but even so, everyone hits an "oops" now and then best way is to think out your declarations before hand. in vb help look up data type summary for most of the fine points. Regards FSt1 "JingleRock" wrote: I have read that the Overflow Error is frequently associated with variable declaration. Do you have any suggestions, other than trial and error in changing declarations, for troubleshooting this error? Thanks for your help. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Troubleshoot Overflow
Don't use "As Integer"; use "As Long".
Don't use "As Single"; use "as double". JingleRock wrote: I have read that the Overflow Error is frequently associated with variable declaration. Do you have any suggestions, other than trial and error in changing declarations, for troubleshooting this error? Thanks for your help. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Troubleshoot | Excel Worksheet Functions | |||
SUM troubleshoot | Excel Discussion (Misc queries) | |||
Troubleshoot LOOKUP, please | Excel Worksheet Functions | |||
Troubleshoot help | Excel Discussion (Misc queries) | |||
Troubleshoot a bug in Excel | Excel Discussion (Misc queries) |