Pasting borders and formatting instead of just values

Back again for a seemingly very easy problem that I cannot figure out.

Here is the area that is causing me problems.

Please Login or Register  to view this content.

The part I am having trouble with is at the very end

Please Login or Register  to view this content.

I have specifically formatted the "sourceRange" area so that it looks neater when pasted into excel. However when I change that code to something along the lines of,

Please Login or Register  to view this content.

I receive a syntax error, or an expected end message. If anyone could help with this problem, so that I can paste all the borders and everything else I would greatly appreciate it.

Thanks a lot,

Z

Hello ZEvans12 ,

The syntax should be...

Please Login or Register  to view this content.