View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steven Deng Steven Deng is offline
external usenet poster
 
Posts: 17
Default templated array as function parameters

Hello, I am writing some code to test whether an array is undefined (See
code below). I am passing an array of integers to the function right now,
and I am wondering if i can extend this so that it can be apply to array of
any type (even user defined type). Something like a function template.




Public Function isUndefArray(ByRef a() As integer) As Boolean
Dim l As Long
On Error Resume Next
l = UBound(a)
If Err.Number = 9 Then
Debug.Print Err.Description

isUndefArray = True
Exit Function
End If
isUndefArray = False
End Function