Paste Special Values/Replace - Problems

**Jokacave** · 05-21-2008, 06:11 AM

Hi everybody,

I need your help again.

I have the following code to open 40 workbooks, each one with 2 worksheets (REC & DES), and after copy all the cells in every sheet, paste everything with "Special/values", and make the replacement of all "#N/A", but doesn't work.

Please Login or Register  to view this content.

Any help will be appreciated.
Thanks to everyone

**royUK** · 05-21-2008, 06:31 AM

You don't say what's not working, but try this amended code

Please Login or Register  to view this content.

**davesexcel** · 05-21-2008, 07:03 AM

What part doesn't work?
Maybe the look in part, could use a back slash
example

Please Login or Register  to view this content.

Maybe this could work as well... I didn't test the full code , but it does work for each worksheet

Please Login or Register  to view this content.

**Jokacave** · 05-21-2008, 08:54 AM

RoyUK and Dave

Sorry...
I think the part doesn't work it is this one

Please Login or Register  to view this content.

I try your suggestions and still doesn't work - still have the formulas, not the values, and because of that doesn't replace anything.

Thank you both

**davesexcel** · 05-21-2008, 09:38 AM

Originally Posted by Jokacave

RoyUK and Dave
.............

I try your suggestions and still doesn't work - still have the formulas, not the values, and because of that doesn't replace anything.

Thank you both

Is the code opening the workbooks?