Merge Multiple files, pasting values only

[robbyvegas]

I could really use some help ASAP if anyone knows how to do this...

I'm trying to use the code that Pike posted for me in a separate thread as follows:

Please Login or Register  to view this content.

I believe that I'm specifically having trouble with the following bit:

Please Login or Register  to view this content.

It runs fine, but the returned values are mostly #REF because they refer to items that are calculated from other values in the source worksheets. Is there a way to do the equivalent of a paste special to paste over just the values of the data that I'm copying?

Thanks,
Rob

[pike]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.