Hi Matthew,

I am sorry for confusion. I don't think there is such function to achieve
your aim.
Did Rob Bovey answer your question?

Regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

--------------------
Date: Fri, 19 Sep 2003 09:59:11 -0400
From: Matthew Wieder
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4)
Gecko/20030624 Netscape/7.1 (ax)
X-Accept-Language: en-us, en, he
MIME-Version: 1.0
Subject: XLL Formula Reference
References:

In-Reply-To:
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID:
Newsgroups: microsoft.public.excel.programming
NNTP-Posting-Host: 207.106.112.178
Lines: 1
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.programming:417361
X-Tomcat-NG: microsoft.public.excel.programming

You gave VBA code, but I need to know IN THE XLL (C++) how to do it.
Also, what you wrote is backword - is there is a formuale currently
evalutaing, I need to know what cell that formula is in; not what you
gave which is what formula is in a certain cell.
thanks!


Peter Huang [MSFT] wrote:
Hi Matthew,

You may try to use the range.formula.
Here is my code.
Sub f()
Msgbox ActiveSheet.Range("F4").Formula
End Sub

Did this answer your question?

Regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no
rights.

--------------------

Date: Thu, 18 Sep 2003 16:56:27 -0400
From: Matthew Wieder
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4)

Gecko/20030624 Netscape/7.1 (ax)

X-Accept-Language: en-us, en, he
MIME-Version: 1.0
Subject: XLL Formula Reference
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID:
Newsgroups: microsoft.public.excel.programming
NNTP-Posting-Host: 207.106.112.178
Lines: 1
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.programming:417179
X-Tomcat-NG: microsoft.public.excel.programming

We inherited an xll which provides a formula that can be used in a cell
in Excel. If someone uses that formula on a spredahseet (let's say in
cell F4) and then they recalc, is there some way for us in that xll code
to know that the formula is in cell F4?
thanks!