Here's something I thought might be useful, but I'm not yet sure how.
Continue Reading: Table array hardcoding »
Building strings for arrays
April 28, 2010 by · 
I don't know about you, but I hate building strings for arrays. That's where you have to wrap each string in double quotes and delimit with a comma, like this:
From
"Once upon a time"
to
"Once","upon","a","time"
Invariably, I make a mistake in typing (stupid fingers!) and have to correct it. So I came up with a way to generate it automatically. Enter the QuoteString function!
Continue Reading: Building strings for arrays »
Building a string from an array
April 9, 2010 by · I'm sure this has been done before. But I couldn't find any code samples (really!), so I wrote my own.
Here's how I build a string (for message boxes and such) from the contents of an array.
Continue Reading: Building a string from an array »
Return Command bar info in a VBA function
February 3, 2010 by · In the previous post I showed a simple sub for listing most of the CommandBar properties. But we can also return this information using a function.
You might do this (in Excel versions prior to 2007) when working with a command bar and need to view its properties before making a change. Here is a function that returns a string array of properties for each Command Bar Object.
Continue Reading: Return Command bar info in a VBA function »
Sorting arrays in parallel
January 8, 2010 by · 
You have two arrays:
placehorses name
3bob
2leo
4kendon
1hippo
5dad
How do you sort the "place" array so the numbers are in order, while maintaining "horse" reference integrity? In other words, how do I sort these arrays in parallel?
Continue Reading: Sorting arrays in parallel »
Follow Me