vbnullstring solved the problem I am now getting the results I want.
Thank very much for your help.

On Jul 27, 12:56 am, JMB wrote:
If it doesn't create a problem for any other areas of your code, perhaps use
vbNullString instead of vbEmpty. The underlying numeric value of vbEmpty is
zero. And average ignores text anyway - so it shouldn't create a problem
there.