Thanks Dave,

Using your format I was able to make it non page specific with

With ActiveSheet.UsedRange
.Copy
.PasteSpecial PASTE:=xlPasteValues
End With


Now my program will work perfectly for future months. The boss i
going to love me! Thanks again

--
Message posted from http://www.ExcelForum.com