RE: When is it better to declare a dynamic array as a Variant verses declaring it as a Dynamic Array? Brandt S Fundak 15.Jun.07 01:30 PM a Web browser General 6.0.2 CF2Windows 2000
Declaring it as a string is always going to be more efficient because you are going to use less memory to declare the array. Declaring a variant is the most high cost way to declare a variable like this.
My rule of thumb is to always declare my dynamic arrays to the datatype I am expecting. If you are using the Variant method because you won't know the size of the value you are passing to the array, I would strongly suggest looking in the Designer documentation about Lists, which are really powerful and easy to resize.
I tend to reserve using variants in functions for when I am expecting to pass an object, usually something from OLE/COM (like an excel object) or when I know that a function can work on similar types of NotesObjects (like say a function that does something to a NotesViewEntryCollection OR a NotesDocumentCollection. I just test for the object type before I run the function.