Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
trap overflow of an division in vba
Hello,
how can I trap an overflow error for a division made in vba code? Example: .. other coding .. If IsError(.Cells(1, 1).Offset(0, -2).Value / .Cells(BaseRangeRow, 1).Offset(0, -2).Value) Then .Cells(1, 1).Value = CVErr(xlErrNA) Else .Cells(1, 1).Value = .Cells(1, 1).Offset(0, -2).Value / .Cells(BaseRangeRow, 1).Offset(0, -2).Value End If .. other coding .. When the denomonator is 0, then the procedure stops with an eeror message "Overflow" Any idea to manage this situation? Excel XP SP3 WIN XP SP1 Regards Werner |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
trap overflow of an division in vba
Use On Error
-- Gary''s Student - gsnu2007g "Werner Rohrmoser" wrote: Hello, how can I trap an overflow error for a division made in vba code? Example: .. other coding .. If IsError(.Cells(1, 1).Offset(0, -2).Value / .Cells(BaseRangeRow, 1).Offset(0, -2).Value) Then .Cells(1, 1).Value = CVErr(xlErrNA) Else .Cells(1, 1).Value = .Cells(1, 1).Offset(0, -2).Value / .Cells(BaseRangeRow, 1).Offset(0, -2).Value End If .. other coding .. When the denomonator is 0, then the procedure stops with an eeror message "Overflow" Any idea to manage this situation? Excel XP SP3 WIN XP SP1 Regards Werner |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
trap overflow of an division in vba
On 4 Apr, 16:14, Werner Rohrmoser wrote:
Hello, how can I trap an overflow error for a division made in vba code? Example: . other coding . If IsError(.Cells(1, 1).Offset(0, -2).Value / .Cells(BaseRangeRow, 1).Offset(0, -2).Value) Then * *.Cells(1, 1).Value = CVErr(xlErrNA) Else * *.Cells(1, 1).Value = .Cells(1, 1).Offset(0, -2).Value / .Cells(BaseRangeRow, 1).Offset(0, -2).Value End If . other coding . When the denomonator is 0, then the procedure stops with an eeror message "Overflow" Any idea to manage this situation? Excel XP SP3 WIN XP SP1 Regards Werner Hi Werner If "denominator" = 0 Then 'Do nothing Else Run code End if Regards Steve |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
trap overflow of an division in vba
Thanks Scoops,
simple and good. Werner |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
trap overflow of an division in vba
Thanks Gary,
yes, works as well. Werner |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Overflow | Excel Programming | |||
Overflow | Excel Programming | |||
can't trap overflow error! | Excel Programming | |||
VBA overflow | Excel Programming | |||
VBA overflow | Excel Programming |