Quote Originally Posted by JBeaucaire View Post

I think this is a patently bad idea, by they way. You're in the process of cycling through files in a folder and then you start adding files to that folder.... I bet this macro would run out of control.

I'd recommend you have a folder INSIDE this folder called "Values" and you save these new copies into that folder instead.

[/CODE]
If I'm reading your post correctly, the macro would actually open all of the individual files in the folder and paste their contents as values into the corresponding tab in the master?? If so I could definitely see how saving the new individual (value) files in the folder could be a problem, otherwise, I don't follow how it would.