Excel sum not updating

The following code will split the string into an array of three elements.

The Split function is normally used when you read from a comma separated file or another source that provides a list of items separated by the same character.

The following code shows the above student example using an array The advantage of this code is that it will work for any number of students.

The array created by the Array Function will start at index zero unless you use Option Base 1 at the top of your module. In programming it is generally considered poor practice to have your actual data in the code.

However sometimes it is useful when you need to test some code quickly.

You assign value for both array types the same way.

The number of the location is called the subscript or index.

Leave a Reply