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
More array matching August 30, 2012 by JP Comments In Checking arrays for exact matches I showed how a simple one-line function can check if a given value is in an array. Continue Reading » Filed Under: VBA Tagged With: array, match, substring
Follow Me