Posted to microsoft.public.excel.programming

Otto Moehrbach[_2_] Otto Moehrbach[_2_] is offline

external usenet poster

Posts: 1,071

OverFlow

Excel 2007, Win 7
I have the following line of code wherein I want to average the occupied
cells in TheRng, and ignore the blank cells:
Cells(1,2) = Application.Sum(TheRng) / Application.CountA(TheRng)
I get an error with the single word "Overflow".
What does that error message mean? Thanks for your time. Otto

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	jmdaniel	Excel Programming	4	September 5th 06 07:09 PM
Overflow	Erik Beck Jensen	Excel Programming	2	December 13th 05 10:11 AM
Problem with overflow	Peter	Excel Programming	1	November 2nd 05 06:34 PM
VBA overflow	Tom Ogilvy	Excel Programming	3	September 2nd 03 09:04 PM
VBA overflow	Don Guillett[_4_]	Excel Programming	2	September 2nd 03 04:19 PM

All times are GMT +1. The time now is 06:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us