Posted to microsoft.public.excel.programming

Bishop

external usenet poster

Posts: 208

Overflow Error

I have the following code:

Dim varSum As Integer, varCount As Integer
Dim ScoringAve As Double
Dim i As Integer
For i = 1 To 18
If Me.Controls(ScoreBox(i)).Text < "" Then
varSum = varSum + Me.Controls(ScoreBox(i)).Text
varCount = varCount + 1
End If
Next
ScoringAve = (varSum / varCount)

Why am I getting an Overflow error for ScoringAve?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
overflow error	Brad	Excel Programming	4	April 2nd 09 10:39 PM
Overflow error.. why?	Fingerjob	Excel Discussion (Misc queries)	4	November 13th 06 05:18 PM
Overflow error, need help	mkerstei[_15_]	Excel Programming	3	July 14th 06 03:10 AM
Overflow error	Grd	Excel Programming	1	January 21st 06 08:13 AM
overflow error	ExcelMonkey[_5_]	Excel Programming	6	January 22nd 04 02:34 AM

All times are GMT +1. The time now is 09:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us