Hello, Everyone.

I recently had a problem with copy and paste values.

I try to explain in detail:

I'm automating some processes that are done through excel. Mainly, the sheets are populated through VLOOKUP:

1. Insert a formula in the right cell (

**ex.** A1)

2. Find the next empty, starting from cell "A1" -> output will use for range class (

**ex.** "row output"). I used this action because the range isn't always the same.

3. Extend formula from A1+1 to A("row output -1)

4. After this, I remove the formula and I take values. I use copy and paste values (

**ex**. source value("A1"), destination A("row output -1))

Frequently I have this error:

"Copy and Paste Worksheet Range Values: Failed to copy worksheet: Error in PasteSpecial method for range class".

In addition, I have this kind of problem when I run the process through control room. If I start the process in debug works 100%.

Can someone help me?

Thanks in advance,

MP

------------------------------

Matteo Pavone

------------------------------