10 Arrays :Variables with a Family Name
10.1 One-Dimensional Arrays
Frequently we work with sets of data whose members are all of the same kind. For example, we might be averaging test grades in a course. If there are 30 class members, it makes more sense to give a common name—for example, test3grade—to the grades and then subscript 30 numbers than it would to enter 30 different student names. In mathematics we might write these as test3grade1, test3grade2, test3grade3, and so on. In VBA we would write them as test3grade(1), test3grade(2), test3grade(3), and so on. Instead of a subscript, we have appended a number within parentheses to ...
Get Numerical Methods with VBA Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
