hi
could mean that you have TheRng dimed as a integer and your average is
producing decimals. could be as simple as rediming to a double. but as Don
pointed out...without seeing your code (and sometimes data), we are only
guessing.

regards
FSt1

"Otto Moehrbach" wrote:

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

.