It has been working for me since 1997.

Perhaps the Change event isn't being fired. Are you updating the cell
using a Data Validation dropdown - if so, then if the source data is from a
worksheet range, there is your Huckleberry.

That situation didn't trigger a change event in xl97.

--
Regards,
Tom Ogilvy

"JK" wrote in message news:p%_Ze.4311$211.4252@trnddc08...
I want worksheet_change to fire a macro only when a specific cell is
changed. In XP, Target.Address="$A$1" works to identify the cell being
changed. But in Excel 97 it doesn't. Does anyone know what will work in
Excel 97 and Excel XP? Thank you in advance.

Jim Kobzeff