Chuck

Suggest you post the code you have for everyone to review

Cheers
N

"Chuck Taylor" wrote in message
...
On Fri, 5 Dec 2003 07:41:25 -0000, "Nigel"
wrote:
Thanks for the tip. I don't know what I'm doing but the behavior of
the worksheet_change is really strange.

I'll put a breakpoint in the "If Target.address = $x$y" line and it
will never get triggered although I know the $x$y cells are changing.
That's really the problem I have - even with a breakpoint, I can't get
the breakpoint to ever be executed (so I can examine the
target.address).

Sometimes, however, it triggers all the time despite the
"Application.Eventenable=false" line I put in before calling the
macro. I'll hit break to stop the execution and then examine the
target.address from the debug line and it will have an address that
has no relation to what I'm doing.

I just can't get consistent execution.

Chuck, try using this code behind the worksheet you are trying to detect
the
change in. I can only think you have the change event in the wrong
place?

Private Sub Worksheet_Change(ByVal Target As Range)

MsgBox Target.Address

End Sub

Cheers
N





----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---