Look If Statement

Originally Posted by STEVEB

Thanks Mark, I appreciate your help!

I receive the following error messsage:

Run Time Error 424 - Object required

At this line:

If Target.Column = 1 Then

Any sugestions?

Thanks

Mark's routine seems to be OK. Just check that you have copied it correctly. Also I hope the procedure is on the code sheet of your worksheet. ( Rightclick the worksheet tab and then click 'view code'. Paste the procedure given by Mark on this code sheet.) It should work.

A V Veerkar