No. Calculate does not pass an argument that indicates which cell triggered
the event.

Change does not fire on a change caused by a calculate.

If you can't pick it up by examining the values in the cells, it would be
difficult to determine.

All that said, the calculate is being stimulated by some action. You can
pick up a cell being manually or programmatically changed with the Change
event. You can pick up a DDE change with the Change event. If you can
translate that to the specific action you need to take, then it should work.

--
Regards,
Tom Ogilvy



"Marcus Schöneborn" wrote:

»Tom Ogilvy« wrote:
You would need to use the Worksheet_Calculate event to fire a macro to
convert B1 to a string value.

Right click on the sheet tab and select view code

select Worksheet from the left dropdown of the resulting module and
Calculate from the right dropdown

Private Sub Worksheet_Calculate()

End Sub

now put in the code that checks the conditions and sets conditions to get
the functionality you want.

That's quite tedious, as I want to do this not for one cell, but default
an entire column that way... but I guess I don't have a choice.

If there is nothing better, it will probably be best to hook
Worksheet_Change and check if the change applies to the "source"
column. But is it really not possible to change the cell currently in
calculation and "de-formula" it?