Aha! Thanks! It works... Now two things:

1) I noticed it being a bit slow and I can only assume it's because
it's running through the entire column each time one of the cells
change. Is there a way to have it only affect the changd cell as
opposed to scanning the whole column?

2) I will also be entering data in the 3rd column which I'd also like
to have .Proper run on. At the moment, the only way to do that is to
run yet another For loop, just like yours, to do that. This adds to
the time it takes updating the entire column.

If there's a way to update and affect just the (current) changed cell,
that'd be great. Suggestions?


Gary Keramidas Wrote:
i fooled around a little with this, it may or may not do what you want.
right click a sheet name and choose view code
click the dropdown (general) and choose worksheet
paste this on the selection change sheet between private sub and end
sub.
then type a name in column A


--
AMK4
------------------------------------------------------------------------
AMK4's Profile: http://www.excelforum.com/member.php...o&userid=19143
View this thread: http://www.excelforum.com/showthread...hreadid=501933