how about
if target.address="$A$1" then

--
Don Guillett
SalesAid Software

"Barb Reinhardt" wrote in message
...
How do I determine what row number the TARGET is located in for a
WORKSHEET_Change event. My target MUST be one cell or this piece of the
code won't work.

Can someone assist?

Thanks,
Barb Reinhardt