Use of hidden function Get.cell in Excel

There are some hidden functions in Excel that enable you to implement functions that are not implemented by existing functions. One of the most important functions is Get.cell. Get.cell translation is the meaning of "get cell", the function is to return the format information in the cell.

function definition: Get.cell (type number, cell (or range))

The type number, which is the type number of the information you want to get, is tested with a range of 1-66, which means that the function can return 66 kinds of information in a cell.

The following is the type and the meaning of the representative

1--the absolute address of the reference cell

2--the column number of the reference cell

3--the column number of the reference cell

4--similar to TYPE function

5--the contents of the reference address

6--text display reference address formula

7--the format of reference addresses, text display

8--text display reference address format

9--back to store extra box left style, digital display

10--back to store extra box to the right style, digital display

11--back to store the extra box on the side of the style, digital display

12--back to store the extra box-side style, digital display

13--back internal pattern, digital display

14--If the cell is set locked returns TRUE

15--returns True if the formula is in a hidden state

16--Back to cell width

17--returns the height of the cell in dots

18--Font Name

19--returns the font size in dots per unit

20--returns True if all or the first character in the cell is bold

21--returns True if all or the first character in the cell is italic

22--returns True if all or the first character of a cell is a single line

23--If you add a horizontal line to the middle of all or the first character fonts in the cell, returns True

24--returns the first character color number of the cell, 1 to 56. If set to Automatic, send back 0

25--ms Excel does not support outline formatting

26--ms Excel does not support shadow formatting

27--Digital display of manually inserted page-line settings