Hi John
this should be one line. I think your newsreader broke it into two
lines. So the line should read:
IF Target.Value = 1 ........ = "credit" Then

HTH
Frank

John wrote:
Hi Frank...

Thanks for your help here. I pasted your code into my VBE and a line
showed up red preventing the code from working...

If Target.Value = 1 And Me.Cells(Target.Row, "C").Value = "credit"
Then

I'm in Excel 97...does this make any difference...

Thanks again...

JC