Copying values (in VB) from multiple file merge

[mlk]

Hello,

I've put together code to merge multiple files together. This works great in most cases, however I now have to merge data that contains formulas, but I only want to copy the values over.

When I run my code currently, I get all sorts of reference errors.

I "bolded" the section below where the copy occurs, but not sure how to work in the "values" only part.

Thanks in advance for any help that can be provided!
Mary-Lou

Please Login or Register  to view this content.

[rylo]

Hi

Try

Please Login or Register  to view this content.

rylo

[mlk]

Perfect!!!! That did the trick.

Thank you very much for your help. Mary-Lou