GET.CELL

[nbrcrunch]

What is "GET"? I cannot find any explanation of the GET as used to precede the CELL function yet I found this post in the archives:

If you want to highlight cells containing formulas (without reverting to VBA !) Posted by Ian on September 28, 2001 9:28 PM

Define a name (let's say, HasFormula) and type in the refers to box =GET.CELL(48,INDIRECT("rc",FALSE))
Select the cells you want highlighted if they contain a formula. Go to conditional formatting, put in the FormulaIs box =HasFormula, and set your format.

I've also checked MS Excel Inside Out, Mr. Excel On Excel and other books.

 

[PaddyD]

http://www.mrexcel.com/board2/viewtopic.php?t=21312


..includes a link to the help file.

 

[nbrcrunch]

Paddy: thanks. I tried searching for GET.CELL on this site but instead got instances of the words Cell and Get that weren't even next to each other in a contiguous string.

At least now I know what and how to use GET.