XML commands - get.cell

[Peter]

Hi.

I found a very helpfull hint to find formula-cells. The trick is to
use the get.cell function. I would like to learn a little bit more
about that function. What does 48 or 6 mean in get.cell(48;.... or
get.cell(6;...

I can't find documentations at the net ?

Regards

Peter

 

[Jim Cone]

Get.Cell(num, cell reference) is a function from XL4 to return information about the formatting, location or contents of a cell.
48... if cells contain a formula it returns True; if a constant it returns False.
6 ... returns the cell formula

Peter Noneley has a free download at...
http://homepage.ntlworld.com/noneley/
which covers some of the XL4 formulas (I can't find get.cell in it).

The 500 plus page Microsoft book... "Function Reference, Microsoft Excel", Document Number 26298-1292, copyright 1992 is my source.
(it was included with Excel)

Note: In VBA, the SpecialCells method for the Range object can be used to return the range containing formulas.
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html
(30+ ways to sort)

..
..
..

"Peter" <[email protected]>
wrote in message
Hi.

I found a very helpfull hint to find formula-cells. The trick is to
use the get.cell function. I would like to learn a little bit more
about that function. What does 48 or 6 mean in get.cell(48;.... or
get.cell(6;...

I can't find documentations at the net ?

Regards

Peter

 

[Dave Peterson]

You can download a couple of files from:
http://www.microsoft.com/downloads/results.aspx?freetext=Macrofun

You can read more about these XLM functions by getting both of these:
Macrofun.exe & Macro97.exe (which contains XLMacr8.hlp)

You may have trouble with macrofun.exe, but macro97.exe creates a .hlp file.

And to me, it sure looks like the content is the same.

 

[Peter]

Thank you Dave and Jim.

It was very helpfull

/Peter