I got it to work but don't know how. Have 3 other worksheet to complete the same type maccro but from different sources. But on thing i try to do is always make my manual edit entry a of "Range ("A1")ClearContents. That way all my recorded events will have to start at A1 until i figure the relative reference problen i have.
Thanks for your code haven't had time to study it yet.

mike in Wisconsin