Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
templated hiring questions for new employees | Excel Discussion (Misc queries) | |||
default save directory for a templated worksheet | New Users to Excel | |||
MSNStockQuote Function Parameters | Excel Worksheet Functions | |||
Function Parameters | Setting up and Configuration of Excel | |||
Implement CSE function through VBA with parameters | Excel Worksheet Functions |