View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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.