VB and VBA Users Source Code: Alternative function to IsArray

VB/VBA Source Code
Alternative function to IsArray

By:	Chris Mason
Email (spam proof):	Email the originator of this post
Date:	Thursday, September 21, 2000
Hits:	1046
Category:	Visual Basic General

Article:
Listed below is a simple alternative function to VB's IsArray: {PS Like your automatic code header download} 'Purpose : Tests if a variable contains an array 'Inputs : vVarName Variable to test 'Outputs : Returns True if variable contains an array 'Author : Chris Mason 'Date : 21/09/2000 20:05 'Notes : Alternative to IsArray 'Revisions : Function IsArray2(vVarName As Variant) As Boolean On Error Resume Next IsArray2 = Right$(TypeName(vVarName), 2) = "()" On Error GoTo 0 End Function
Terms and Conditions
Support this site Download a trial version of the Excel Workbook Rebuilder