formula or function?
 

I'd like to have a macro that will compute the average of the non-blank
elements in a column. Should I use a formula or a function for the
calculating part?

formula or function?
 

Have you tried entering, for example:
2, blank, 3, blank, 4, blank in A1:A4 and using the formula =AVERAGE(A1:A4)
?
If you try this you will find that AVERAGE ignores blanks

Note we have a formula - it begins with =
But our formula incorporates a function - AVERAGE

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"grok" wrote in message
...
I'd like to have a macro that will compute the average of the non-blank
elements in a column. Should I use a formula or a function for the
calculating part?