identifying which cell calls my VBA function.
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)
"y" wrote in message ...
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.
|