VB and VBA Users Source Code: Another alternative to IsArray

VB/VBA Source Code
Another alternative to IsArray

By:	Andrew Baker
Email (spam proof):	Email the originator of this post
Date:	Thursday, October 05, 2000
Hits:	694
Category:	Visual Basic General

Article:
For an internationally friendly version of your IsArray function you could try: 'Purpose : Tests if a variable contains an array 'Inputs : vVarName Variable to test 'Outputs : Returns True if variable contains an array 'Author : Andrew Baker 'Date : 6/Oct/2000 01:05 'Notes : Alternative to IsArray 'Revisions : Function IsArray2(vVarName As Variant) As Boolean On Error Resume Next IsArray2 = (VarType(vVarName) = vbArray) On Error GoTo 0 End Function I personally just use IsArray though!
Terms and Conditions
Support this site Download a trial version of the Excel Workbook Rebuilder