Functions That Return an Array : Function Return « Language Basics « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Language Basics
  3. Function Return

Functions That Return an Array

 
  Function MonthNames()
      MonthNames = Array("January", "February", "March", _
        "April", "May", "June", "July", "August", _
        "September", "October", "November", "December")
  End Function

  =TRANSPOSE(MonthNames())








Related examples in the same category

1.return value from user-defined function
2.Specifying the Data Type for a Function's Result
3.Return number from function
4.Passing Parameters and Returning Values
5.Return a string from funtion
6.Returning a sorted list