I think I solved my problem by changing ActiveCell.Offset to
Target.Offset
Thanks for the help.
------------------------------------------------
~~ Message posted from
http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/