Paste values code returns "0"

**GeorgY** · 11-11-2009, 12:21 PM

Hello,

I have a simple code that opens 2 workbooks and then copies and pastes a cell from one to the other. The cell that's being copied is a formula by the way.

My problem is that the copy and paste keeps returning a "0" value, instead of the correct number. I am thinking it's probably because the file from which it is copied is very large and because the operation barely takes a second, it doesn't allow it enough time for the formula int he cell that is being copied to calculate the value.

Any suggestions are appreciate.

Please Login or Register  to view this content.

**shg** · 11-11-2009, 12:25 PM

Have to tried setting a breakpoint after the Selection.Copy line, and see (from the marching ants) if you're copying the right cell?

**GeorgY** · 11-11-2009, 12:59 PM

Originally Posted by shg

Have to tried setting a breakpoint after the Selection.Copy line, and see (from the marching ants) if you're copying the right cell?

Yes, I have. It's the right cell.

**shg** · 11-11-2009, 01:30 PM

The operative change below is that the copied cell is calculated before being copied. The debug lines will allow you to verify that.

Please Login or Register  to view this content.

**GeorgY** · 11-11-2009, 04:23 PM

thanks for that
i tried it and verified that it is copying and pasting from/to the right places

however, the pasted cell is still showing up as "0" instead of the number that is being copied

any other ideas?

**shg** · 11-11-2009, 04:36 PM

What is the cell value following the copy -- where the first Stop statement appears, Georg?

**GeorgY** · 11-11-2009, 07:31 PM

Please ignore that last message. I fixed the problem.

**shg** · 11-11-2009, 07:45 PM

Are you gonna share what the problem was?

**GeorgY** · 11-17-2009, 07:19 PM

There were hidden rows which made it look as if the right cell was being copied, but as a matter of fact, it was another (one of the hidden ones). I used your break code a few times until I saw it.

Thanks again