Posts in the 'VBA' category, page 2 of 33

Useful Array Functions for VBA, Part 3

September 10, 2012 by JP

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

Run VBA code from Excel workbooks automatically using Windows Task Scheduler

August 10, 2012 by JP

6 Comment(s)

Suppose you want to run some VBA code at specific intervals, maybe every day or every week. Using Windows Task Scheduler we can set up our code to run whenever we want.

Continue Reading »

Filed Under: Automation, VBA

Tagged With: BAT, task scheduler, VBS