Worksheet Change Target??

[spinkung]

Hi all,

i am trying to make use of the target in worksheet change event but only when a single cell is change.

problem is that even when the cell is changed it's not going through my if statement.

here's what i have...

Please Login or Register  to view this content.

...but even when the cell B2 is changed it doesn't trigger the message box.

Also, ideally i'd like to change B2 to a named range but i couldn't figure it out?? can anyone help.

thanks

[Richard Schollar]

Hi

You're not comparing the Address to "$B$2" - you're comparing it to the value in B2. So instead you need to write it like:

Please Login or Register  to view this content.

Richard

[spinkung]

worked a treat, thanks.