View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chuck Taylor Chuck Taylor is offline
external usenet poster
 
Posts: 8
Default Trapping Worksheet Target

I'm using the Worksheet.Change function to trigger a macro when a cell
changes. I'm specifying the right cell (Target.Address = $Col$Row)
but I can't get the darn thing to trigger. I want to see what address
is being passed in the If Target.Address.... line.

Using a breakpoint doesn't seem to work. Any ideas?