It depends which technique you're using, but there may be a reference to
the target column, e.g.:

If Target.Column = 3 Then

So, if you're using column A, you're right, you should change the
reference to column 1:

If Target.Column = 1 Then


beckster6701 wrote:
That must be what I'm doing wrong. Just to confirm that the code is to be
modified to reflect the column reference. So if it the data is in column A
it would column 1? Like I said, I'm still very new to VBA so I want to be
sure that I'm getting this right. Thanks for your help.

Becky


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html