Thread: Target.Address Doesn't Work in Excel 97?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JK JK is offline
external usenet poster
  
Posts: 78
Default Target.Address Doesn't Work in Excel 97?
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


Reply With QuoteReply With Quote