Assuming you want the code to run when the user changes the Sheet1!AN2
cell value, you will probably want to use Sheet1's Worksheet_Change
event.

Take a look at the help files and see if that looks like it will work -
you'll need to check if the Target range in that event is AN2 (possibly
by comparing the Target.Address with "AN2" = or "$AN$2" - check which
format the Target.Address returns) and run your code if it is or exit
the sub if the change wasn't in AN2.


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111601