View Single Post
  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default

You can't with that event, the only info passed is the sheet object.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Asaf" wrote in message
...
I'm relating to the Workbook_SheetCalculate event. How can I determine

which
cell triggered the event?
Thanks.

"Bob Phillips" wrote:

Bit more info required. You can react to a cell change event, testing

for a
particular cell. So if you know which cell you want to check, event

code is
easy.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Asaf" wrote in message
...
I am trying to write a small app which will be triggered by the

calculation
(and thus changing of) a cell. What I can't understand is how can I

know
which cell changed?