Copy -> Paste Special -> Values (PROBLEM)

[davehunter]

Hi Guys.

I have a problem with a copy > paste special > values function I am using in a macro.

I have a button that opens a popup to allow a user to select an excel file.

The complete file is then copied using:

Please Login or Register  to view this content.

It is then pasted into the other workbook using:

Please Login or Register  to view this content.

The above code seems to be leaving formulas in my sheet, which then leads to a 'Type Mismatch' error.

Is their something else I should be doing, or is there a way I can guarentee that no formulas are pasted?

Thanks!
Dave

[royUK]

This should copy the cells containing formulas as values to the main workbook

Please Login or Register  to view this content.