| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
average of array element
Glad that worked for you. Thanks for posting back.
"Geoff" wrote: 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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Array element | Excel Worksheet Functions | |||
| Looping through each element of an array | Excel Programming | |||
| Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
| Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
| Array element | Excel Programming | |||
Threaded Mode
