STEVEB Wrote:
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 i
correctly. Also I hope the procedure is on the code sheet of you
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 Veerka
--
avveerka
-----------------------------------------------------------------------
avveerkar's Profile:
http://www.excelforum.com/member.php...fo&userid=3033
View this thread:
http://www.excelforum.com/showthread.php?threadid=51196