Posts tagged with 'array', page 1 of 4

array

The array tag is used when the articles deal with arrays, usually in Excel but in any VBA-aware program.

Useful Array Functions for VBA, Part 5

September 17, 2012 by JP

In my last blog post I promised to continue bombarding you with more custom functions for dealing with arrays. And I know you are excited to read more!

Continue Reading »

Filed Under: VBA

Tagged With: array, intersect, unique

Useful Array Functions for VBA, Part 4

September 13, 2012 by JP

Comments

PHP has a function for adding values to the beginning of an array. Let's look at a few functions that let us append and prepend values to an array.

Continue Reading »

Filed Under: VBA

Tagged With: append, array

Useful Array Functions for VBA, Part 3

September 10, 2012 by JP

3 Comment(s)

In the previous article, we reviewed some VBA functions that populate arrays. In this article we look at a function to resize arrays as well as checking their size.

Continue Reading »

Filed Under: VBA

Tagged With: array, resize, size

Useful Array Functions for VBA, Part 2

September 6, 2012 by JP

Comments

In the previous article, we reviewed a VBA function that creates arrays for us. Now let's look at two functions that help us populate them.

Continue Reading »

Filed Under: VBA

Tagged With: array, fill

Useful Array Functions for VBA, Part 1

September 3, 2012 by JP

Comments

The following is a series of articles demonstrating some useful array functions which you can hopefully use to make working with arrays easier.

Continue Reading »

Filed Under: VBA

Tagged With: array