Array keyword

A second approach is to use the Array keyword. The Array function returns a variant that contains an array. In the Sub procedure shown in Figure 15-12, the variable MyArray contains an array of text values, but an array can contain text, number values, the value of a VBA variable, even a Range reference. 

Shows another way to return an array of values the Array keyword Array returns a single variable of Variant type that contains an array. 

Figure 15-12. Using the Array keyword in a Function procedure.

The Array keyword can accommodate only a one-dimensional array. To use this approach to return a two-dimensional array, you can create an array of arrays, as illustrated in Figure 15-13. This function returns the letters a, b, c and d in a 2 X 2 array. 

Figure 15-13. Using the Array keyword to return a 2-D array.

Many of Excel s worksheet functions can accept an indefinite number of arguments. The SUM function is an example of such a function its syntax is =SUM(number1,number2,...). To create a custom function with an indefinite number of arguments, use the Param Array keyword. An argument declared with ParamArray is an array of Variants, and each element of the array can itself be an array. 

MOPAC runs in batch mode using an ASCII input hie. The input hie format is easy to use. It consists of a molecular structure dehned either with Cartesian coordinates or a Z-matrix and keywords for the type of calculation. The program has a very versatile set of options for including molecular geometry and symmetry constraints. Version 6 and older have limits on the size of molecule that can be computed due to the use of hxed array sizes, which can be changed by recompiling the source code. This input format allows MOPAC to be run in conjunction with a batch job-queueing system. 

Keywords electronic nose principal component analysis pattern recognition chemical sensors sensor arrays olfaction system multivariate data analysis. 

Fig. 2 Number of publications (only in English) in the last 8 years found by SciFinder using as keyword Xi02 nanotube or Xi02 nanotube array as entered and concept.

Keywords wrinkling Thin-film Elastomeric polymer Polydimethylsiloxane Patterns Deformation Surfaces Self-assembly Polyelectrolyte multilayer films Thin-films Polymer brushes Colloidal crystallization Mechanical-properties Assembled monolayers Buckling instability Elastomeric polymer Tobacco-mosaic-virus Soft lithography Arrays... 

Keywords Iridium complexes Cyclometalating ligands Phosphorescence Electrochemistry Multicomponent arrays OLEDs Photoinduced processes... 

Keywords membranes, series arrays, differential description, incremental description, po-... 

Keywords Polynucleotide arrays, hybridization, sequencing, DNA chip. 

Keywords Integrated miniaturized sensor arrays, microfluidics, biosensors, microelectronic, microsystemtechnology. 

Keywords. Artificial nose, Chemical multisensor array, Artificial neural network, Bioprocess... 

Keywords Focal Plane Array FTIR Imaging Infrared spectroscopy Polymer blends... 

Keywords Total internal reflection Fluorescence Biosensor Chemical sensor Multiplex detection Array... 

Keywords Nanohole array Surface plasmon resonance Optical sensing Chemical sensing Biosensing Microfluidic Nanofluidic Extraordinary optical transmission... 

Only one argument can follow the ParamArray keyword, and it must be the last one in the function s list of arguments. The argument declared by the ParamArray keyword is an array of Variant elements. Empty parentheses are required. 

Elements in the array of arguments passed using the ParamArray keyword can themselves be arrays. 

Since FINEST requires that there be the same number of values for each independent variable, we first check to make sure that each range in the array of arguments has the same number of rows. An interesting point although we specified Option Base 1, the ParamArray keyword produces an array whose lower array index is zero. Thus we must loop from 0 to UBound(rng). Note that UBound(rng) is the number of elements in the array, while... 

If an array element is not the correct size, we need to return an error value. Use the CVErr keyword to return a worksheet error value that Excel can handle appropriately. The error values are listed in Appendix D. 

MakeArray.xls is a Function procedure that combines individual worksheet ranges into an array. This Function procedure illustrates the use of the ParamArray keyword. 

Keywords Biosensor Titania nanotube array Hydrogen peroxide Amperometric detection... 

Keywords DNA arrays, Poisson-Boltzmann equation, molecular dynamics simulations,... 

Keywords High performance liquid chromatography (HPLC), Analytical biotechnology, Sample preparation, Diode-array-detection (DAD), Mass spectrometry (MS), Validation, Preparative chromatography, Competitive isotherm parameters, Perturbation peak (PP) method... 

The Java applet that comes with NMRShiftDB includes an array of features for molecular display (such as ball-and-stick, wireframe, space-fill, etc.), translation into SMILES nomenclature, and possibility of structure editing. Searching of chemicals can be based on (amongst others) chemical name, keyword, CAS number, literature title/author, and chemical formula. 

Keywords GeneChip array, Oligonucleotide probe array. Photolithography, Gene expression monitoring, Genotyping... 

Keywords Sequencing, Hybridization, Oligonucleotide, Arrays, Ligation... 

Keywords Protein Array, Expression Profiling, Automation, Serum Screening, Antibody Profiling, Protein Purification... 

---