The code is working now. I had to remove "Public" and then it did what I
needed. Thank you a ton!

"Bernd Plumhoff" wrote:

Hi Steve,

Hmm, my spreadsheet works fine:
One solution is
11 14 2 7 2 0 7 -4 0 10 13 -4 7 7 9 2 -4 3 0 10 -2 -3 7 9 -1 -5 7 0 1 4 7 3 7 -3 11 11 12 10 -5 6
Another
-2 -5 9 8 -1 0 6 12 9 -2 4 3 6 4 0 13 10 7 1 13 9 2 -4 -5 14 -1 9 -2 4 12 -1 -3 6 3 9 -2 4 6 -3 13
Did you place the =Average(A1:A40) exactly into cell C3 and the desired
value 4.2 into D3?
The macro is referring to these cells...
If you post your email address I can send you my file (make a verbal
description only to confuse spam harvester!).

HTH,
Bernd