Getting Values from a Worksheet

To transfer values from worksheet cells to a procedure, use a reference to a worksheet range in an assignment statement, like the following. 

The corresponding Formula property is used to obtain the formula in a cell, rather than its value. 

---

There are at least two ways to get values from a worksheet into a VBA array. You can either set up a loop to read the value of each worksheet cell and write the value to the appropriate element of an array, or you can assign the VBA array to a worksheet range. These two methods are described next. There is a definite difference with respect to speed. (See "Speed Differences in Reading or Writing Arrays Created by Two Different Methods" later in this chapter.)... 

---