Worksheet getting values from

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.)... 

If you enter 10 AM in cell A1 of a worksheet, and =A1 +3 in cell B1, you may at first be confused when cell B1 displays 10 00 AM. But remember that you ve added three days, not three hours if you apply the date format m/d/yy to the cell, you ll see that you ve calculated a date three days from the current date. If you change the formula to =A1+3 00, you get an "Error in formula" message. That s because 3 00 is not a numerical value. To obtain the desired result, 1 00 PM, use the formula =A1+"03 00 . Excel recognizes that 03 00 is text and evaluates it just as it would if you d typed it into a cell. 

Instead of a macro that gets the contents of the active cell or a selection, you may want to create a macro that copies values from specified rows and columns in a worksheet, independent of where the cursor has been "parked" by the user. To accomplish this, you can use either the Range method or the Cells method to make a reference to a cell or range. The syntax of the Cells method is Cells(roiv, column). The first two of the following refer to cell B3, the next two to the range B3 E27. 

FMEA worksheets will typically identify whether corrective action is required based on a combination of severity, occurrence, detection, and/or RPN values. After RPN assessment, recommended actions are suggested. After implementation of the recommended action, the entire issue is reassessed to get an indication the effectiveness of the corrective action. Naturally, with a revised set of severity, occurrence and detection ratings a new RPN is calculated. From these two values it is possible to get % reduction in RPN ... 

---