Copy & Paste Values To Separate Workbook

So I've gotten most of what I need figured out through trial and error. I'm just having trouble with this last bit. Pasting values using the same format I already used to copy other sheets.

Any help?

Please Login or Register  to view this content.

change this line:

Please Login or Register  to view this content.

to this line:

Please Login or Register  to view this content.

That does work, but doesn't give me the values and not the formulas.

didn't know that was what you wanted. try this:

Please Login or Register  to view this content.

Thanks so much. I apologize for not being clear. Going on no sleep. I was looking for the values and not the formulas. Thanks to you I figured it out. This is what I'm going with unless you tell me it won't work for some reason.

Please Login or Register  to view this content.