Thank you I will look at that. I am also working on a new sheet that I will want to copy information from the MDS sheet into I am going to add it to a sample and post once done...
Quote Originally Posted by Paul_Hossler View Post
Remove this line


.Offset(0, 1).Resize(1, .Parent.Columns.Count - 2).ClearContents