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