Trapping Worksheet Target
Since you asked for "any ideas", an untested one would be to use a message
box in the sub to display the target address.
Let us know if this works!
James Cox
"Chuck Taylor" wrote in message
...
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?
|