• Home ▼
    • Visitor Survey
  • Excel VBA
  • Outlook VBA
  • VBA
  • About ▼
    • FAQ
    • Downloads
    • Legal
    • Spread the word
    • Credits
  • Blog ▼
    • Comment Policy
    • Subscribe
  • Site Map
  • VBA Search Engine
  • Contact ▼
    • Contribute
  • Add-Ins
  • Shop

JP Software Technologies Blog

Custom Office Programming and Automation

You are here: Home » Blog
VBA icon

Useful Array Functions for VBA, Part 4

calendar date September 13, 2012 by JP comment bubble 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 »

categories Filed Under: VBA tags Tagged With: append, array
VBA icon

Useful Array Functions for VBA, Part 3

calendar date September 10, 2012 by JP comment bubble 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 »

categories Filed Under: VBA tags Tagged With: array, resize, size
VBA icon

Useful Array Functions for VBA, Part 2

calendar date September 6, 2012 by JP comment bubble 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 »

categories Filed Under: VBA tags Tagged With: array, fill
VBA icon

Useful Array Functions for VBA, Part 1

calendar date September 3, 2012 by JP comment bubble 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 »

categories Filed Under: VBA tags Tagged With: array
VBA icon

More array matching

calendar date August 30, 2012 by JP comment bubble 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 »

categories Filed Under: VBA tags Tagged With: array, match, substring
  • «Previous Page
  • 1
  • 2
  • 3
  • 4
  • 5
  • …
  • 100
  • Next Page»

Follow Me

Follow me on Google+Follow me on TwitterFollow me on LinkedInFollow me on Stack OverflowFollow me on RSSFollow me on E-mail
Excel School

Categories

  • .NET (3)
  • Access (25)
  • AddIns (40)
  • Administrative (54)
  • Automation (38)
  • Excel (190)
  • Internet Explorer (7)
  • Java (4)
  • Off Topic (4)
  • Office (15)
    • Office Cafe (8)
  • Outlook (108)
  • PHP (1)
  • Rant (18)
  • Tutorial (7)
  • VBA (161)
  • Word (6)

Tags

Access add add-in addin API array attachment attachments autofilter Automation best practice comparison test contacts contest CreateItem CreateObject database DistListItem Excel export extract forward GetDefaultFolder GetObject hyperlink import ItemAdd Len Links MSXML MSXML2 Outlook QuickSteps Reply Restrict ShipTrack stats table toolbar training trim userform VBA vlookup XMLHTTP

Recent Posts

  • ADODB Code to Trim Text Fields
  • Random Data Generator 3.3.0 now available
  • ShipTrack 4.2.5 now available
  • 2013 State of the Blog
  • Updated code to trim all text fields in a MS Access database
Random Data Generator

USA Back to Top

Copyright © 2013 Jimmy Peña · Hosted by FutureQuest · Powered by Genesis · Legal