Figure 49 Offset Function Arguments Dialog

= Volatile

Returns a reference to a range that is a given number of rows and columns from a given reference.

To turn the letters of the column title lines (A, B, C, and so on) into numbers while working in the worksheet:

1. From the Tools menu, select Options.

2. Select the General tab, and select the R1C1 Reference Style check box.

Chapter 4

0 0

Post a comment