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
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
I agree. Here's the link:
subject: excel VBA question
It's not a secret anymore!