Copy pasteSpecial Values after rngCopy

Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.