File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Engineering » General Computing
Bookmark "excel VBA question" Watch "excel VBA question" New topic

excel VBA question

Jackie Wang
Ranch Hand

Joined: Apr 18, 2002
Posts: 315
ColumnA ColumnB

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
Don't get me started about those stupid light bulbs.
subject: excel VBA question
It's not a secret anymore!