identifying which cell calls my VBA function.

[y]

My formula is spread over 1000 cells. Only in some of these it is wrong.
I would analize the code when the code runs for those cells.
So I would set a breakpoint that consider the calling cell.
I don't want to move my formula, and others one it needs, to a new workbook and reproduce the
conditions for tose cells.

Thanks you, Alex.

 

[Bob Phillips]

Something like

If Application.Caller.Address = "$A$1" Then
' do your stuff

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Vasant Nanavati]

Application.Caller.Address

will give you the location of the cell that calls your UDF.

 

[Peter Huang]

Hi Alex,

Did Bob and Vasant's suggestion that use the Application.Caller.Address
works for you?
If you still have any concern on this issue, please feel free to post here.


Best 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.