aspose file tools*
The moose likes General Computing and the fly likes excel VBA question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Engineering » General Computing
Bookmark "excel VBA question" Watch "excel VBA question" New topic
Author

excel VBA question

Jackie Wang
Ranch Hand

Joined: Apr 18, 2002
Posts: 315
ColumnA ColumnB
#N/A=myaverage(A1:A5)
#N/A=myaverage(A1:A5)
3=myaverage(A1:A5)
5=myaverage(A1:A5)
0=myaverage(A1:A5)

Function name: MyAverage
Input: the array of the above 5 cell (I hope i can be dynamic)
output: average of the non #NA cell. In this case 2.3333
Can anyone shed some light to write this little macro
Sameer Jamal
Ranch Hand

Joined: Feb 16, 2001
Posts: 1870
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: excel VBA question