Changing Current Code from Paste Formulas to Paste Values

Hello Everyone,

I have some code here that I got help with a while back - I've looked through it and I'm not exactly sure of the best way to change it so that the macro pastes values instead of formulas.

In case it helps, a quick rundown of what this code does:

It goes through each Excel file in a folder, copies a certain portion of the file, then pastes it in order in the macro workbook. Again, my goal is for the macro to copy the portion of each file and paste it in to the macro workbook so all formulas are now just values.

Here is the code:

Please Login or Register  to view this content.

If you can find anything else in here that you think might speed it up or help, I'm always open for suggestions!

Thanks in advance!

Hi Norie,

That doesn't seem like an option according to VBA. I'm getting a compile error when I try to enter that code.

When "rToCopy.Copy rNextCl" is changed to "rToCopy.Copy rNextCl.PasteSpecial xlPasteValues" I get:

"Compile error: Expected: end of statement" and the xlPasteValues part is highlighted.

Ah - My apologies. I thought it needed to be like that due to thats the how the code was originally put together. It looks like everything works now!

Thanks for your help Norie! You are amazing!